SumOver Issue with decimal Number

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!