Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Incorrect Total on table from multiple measure output

Hi,

I have issue where the below measure is not providing the correct total on my table

DMR Var ABS = IF(ABS([Actuals] - [FC Lag 4])>[FC Lag 4],[FC Lag 4],ABS([Actuals] - [FC Lag 4]))

 

The total I am expecting is 3239 but the visual is displaying 3335. This measures are stacked from existing measure to get this value and I would appreciate any help. 
Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous 

    [FC Lag 4] , because the ABS() function returns positive numbers, if there are complex numbers in [FC Lag 4], it may be that the calculation result is biased, because the results calculated at this time are all qualified, if [FC Lag 4] is negative.

     

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.