Formula Implementation

[#1]

Hi,

I have table chart and have one KPI like the below formula.

SUM(Sales+Profit+Revenue+Gain+Value) where Sales+Revenue+Loss-gain>0, I am not sure how to implement this kind of logic, I tried to put Sales+Revenue+Loss-gain in variable and use it in the SUM SET expression, but I believe we can't use variable on left side for the comparison.

Can you pls assist me to achieve this formula.

Thanks,

[sunny_talwar]

Have you tried this:

If(Sum(Sales+Revenue+Loss-gain) > 0, Sum(Sales+Profit+Revenue+Gain+Value)) as your expression

Best,

Sunny

[MarcoWedel]

Hi,

one possible solution could be:

SUM(If(Sales+Revenue+Loss-gain>0 , Sales+Profit+Revenue+Gain+Value))

hope this helps

regards

Marco