Conditional calculated measure in front end?

[devarasu07]

Hi All, ‌

attached report is working fine using back end script method. but i'm looking forward to do in front end instead of doing in back end script method.

just need to derive the Regular sales % calculated measure (highlighted red is expected output.)

Thanks

Deva

[sunny_talwar · Accepted solution]

This:

=Sum(Aggr(If(((Sum(TotalGrossPrice)-Sum(TotalNetPrice))/Sum(TotalGrossPrice)) < 0.15, Sum(TotalNetPrice)), Country, Product))/SUM(TOTAL <Country,Product> TotalNetPrice)

[devarasu07]

Hi Sunny,

It's Working perfectly, Thanks

[sunny_talwar]

Another approach using set analysis

=Sum({<Key = {"=((Sum(TotalGrossPrice)-Sum(TotalNetPrice))/Sum(TotalGrossPrice)) < 0.15"}>} TotalNetPrice)/SUM(TOTAL <Country,Product> TotalNetPrice)