Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
Have you tried this:
If(Sum(Sales+Revenue+Loss-gain) > 0, Sum(Sales+Profit+Revenue+Gain+Value)) as your expression
Best,
Sunny
Hi,
one possible solution could be:
SUM(If(Sales+Revenue+Loss-gain>0 , Sales+Profit+Revenue+Gain+Value))
hope this helps
regards
Marco