Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I'm trying to create a graphic of trend of costs in each month, where:
Column 1 reports costs for each month of 2011;
Column 2 reports costs for each month of 2012;
Column 3 reports the difference between costs of 2011 and 2012;
Column 4 reports the difference between costs of 2011 and 2012 in percentage;
When cost of 2012 is null, I'd like to show the cost has decreased by 100%.
Can anybody help me to fix my expression? Maybe with the example attached.
Thank you for any help you can provide in this situation.
Regards,
Andrea
Hello Andrea!
Why doesn't it work?
If 2012 is 0 the ratio 2011/2012 it is impossible to be calcuated.
What would you like to display?
Hi Elena,
I'd like to show the cost has decreased by 100%.
Thank you for your help!
Oh yes!
Can you check the attachment?
PS: maybe replace <100% with -1 in my expression, in order to be coherent with other % values... sorry.
