Forum Discussion
Measure madness
Thanks for the suggestions guys.
In the end I figured it by accident when trying to debug.
Basically the measure YoY FB% had a format of Percentage and was behaving as expected.
The measure YoY FB, which is the nominal representation of YoY movement, was of format Currency. And NOT behaving as expected. For FB < FBPreviousYear, the YoY should be negative. But it was always showing as positive.
If I changed the format to anything else, like general, number etc., it would show as negative.
Not sure if this is documented somewhere, but maybe the currency format only show absolute values?
Thanks
Tor
Try YoY FB% = DIVIDE([FB] - [FBPreviousYear]) ;[FBPreviousYear] ) since probably the division is happening before substraction..
Sorry, provided same results as the existing formula.
It is mathematically possible if the value for [FBPreviousYear] is negative
positve - negative = positive
positive / negative = negative
If you want to abstract the sign of youre result you can use the matematical function ABS().
It's return the absolute value of the parameter.
