Return on Ad Spend

[Anonymous]

What information is needed to determine the ROAS? 

The formula I have is [NPV Sum] - [Expense Sum] ; but the values do not look correct. 

[NPV Sum] = Sum( 'SalesTable' [NPV Value] )

[Expense Sum] = Sum( 'VendorTable' [Expense] )

[v-huizhn-msft]

Hi @Anonymous,

It's hard to reproduce your scenario without more details. Do you mind share your sample table? If your table is confidential, you can create some fake data similar with your actual data. It said the result of the formula is uncorrect? And what is the correct result? 

Best Regards,
Angelia