Graphic Error Percentage

[#1]

Hi!

I'm trying to create a graphic of trend of costs in each month, where:

1. Column 1 reports costs for each month of 2011;

2. Column 2 reports costs for each month of 2012;

3. Column 3 reports the difference between costs of 2011 and 2012;

4. 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

[Anonymous]

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?

[#3]

Hi Elena,

I'd like to show the cost has decreased by 100%.

Thank you for your help!

[Anonymous]

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.

[#5]

Thank you for your help!