Please kindly assist me in getting the expression correctly .

[suvechha_b]

Hi All ,

Please kindly assist me in getting the expression correctly .

My requirement is if there was a increase from the previous month the ration should display in green , and if there is a decrease , it should be shown as red.

Say for eg , the Ratio for month Mar 2018 should be red as it decrease . and April should also be red.

Sample model attached.

Thanks,

[sunny_talwar · Accepted solution]

Try Before() instead of Above()

=if(Before([Ratio])>([Ratio]),rgb(255, 0, 0),Green())

[sunny_talwar]

Also read about Before() and After() functions here

Missing Manual - Before() and After()

[suvechha_b]

Thank you