Forum Discussion

KH_Mike's avatar
KH_Mike
Icon for Helper III rankHelper III
5 years ago

Handle negative number to show the performance correctly

Hi All,   I have a set of financial data which contain negative number. I make to measure to sum the "This Year Result" and "Last Year Result". Right now, I would like to create new measure "My IDe...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
5 years ago

KH_Mike When checking the % use ABS for absolute value? Or when caculating the change use ABS for LYR like:

[Change] / ABS([LYR]) 

 

Probably ought to do that anyway.

KH_Mike's avatar
KH_Mike
Icon for Helper III rankHelper III
5 years ago

Hi Greg_Deckler ,

 

Seems the logic should be use the absolute value for % and positive change then "Improve". If negative change then "Not Improve". Thank you.