Forum Discussion

torh's avatar
torh
New Member
10 years ago
Solved

Measure madness

I have 2 measures to calculate Year over Year changes. One in percentage, the other in nominal value.   They look like this: YoY FB% = ([FB] - [FBPreviousYear]) / [FBPreviousYear]  YoY FB = ([FB]...
Need Help
  • torh's avatar
    torh
    10 years ago

    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

     

     

     

     

markvsql's avatar
markvsql
Resolver I
10 years ago

One thing that may help with debugging is to create a measure for [FB] - [FBPreviousYear] and then reference THAT measure in your formauls above.

torh's avatar
torh
New Member
10 years ago

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

 

 

 

 

  • WillT's avatar
    WillT
    Community Admin
    10 years ago
    That definitely sounds like a bug, Tor. I can't reproduce it but if you still see the problem, please Send a Frown from the Desktop we can track it down.