Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Visuals Displaying Negative Values as Zero

I have a measure which takes the difference of two measures (column 3 = column 2 - column1 in the image below) to show change over time. However, in multiple types of visuals (ex., card, matrix), all negative values render as zero. The grand total in a matrix also shows zero, which is only possible if some values from the expression are negative because the total of all values must be zero for this particular measure, so I know the issue relates to rendering negative values rather than not calculating negative values. Does anyone know why this might occur? 

 

 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Just check the formatting on the field and do not under any circumstances format the output of measures using the FORMAT function.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

     

    Can you provide your formula of your measure? If so, can you give me your sample data? Remember to hide your private data.

     

    Best Regards,

    Stephen Tao

     

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