i added Calculation filed in analysis
roi ={net revenue usd} / sumOver(advcost, , PRE_AGG)
but it but Calculation is wrong
but for churn
Churn New=delete/sumOver(new,,PRE_AGG)
its working perfect
1 Like
Hi @sunit,
If you just calculate sumOver(advcost, , PRE_AGG) on its own, do you get 19,481.40?
1 Like
Hello @sunit, that is interesting that it is slightly off. I would convert the numerator into a LAC-W aggregation as well to try and resolve this.
Try changing the ROI calculation to this:
row = sumOver({net revenue usd}, [{date}], PRE_AGG0/sumOver({advcost}, [], PRE_AGG)
I often find more success with the calculations if I utilize the same aggregation type for the whole calculated field. I hope this helps!
Hello @sunit, since we have not heard back with any remaining questions, I will mark my previous response as the solution. If you still need assistance with this topic, let me know and I can guide you further. Thank you!