Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Measure for Conditional Formatting works 50%

  Hello,        I am trying to apply background color on a Matrix that contains a column "Distribution %" :   I want to perform a calculation and set the bg color ro red. The Calcuation is...
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , Try a measure like this and use that in conditional formatting using field value option

 

If( [Distribution %] >[Tmo Target] + [Over Variance] , "Red", "White")

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks for your response amitchandak 

     

    I wrote a measure as you stated:

    OnlyOver_Measure = IF ([% of MB by Total MB all PMN] > SUMX(OutboundVolumes, [Standard Target Display] + [Standard Over Variance Numeric]) , "Red", "Green"  )

    And the result is Distribution % is shown as Green rather than Red.

     

    The Distribution % & TMo Target cols in the Matrix are Measures returning % & Text values respectively. The Over Variance & Under Variance cols contains values of fields of type Text - the original data. 

    To work on the calcuations, I have duplicated the fields & made of type %.

    To debug the above issue, I added those created % fields in Matrix, and I see different values than what it is in the data, they are shown as Sum & not just value.

     

    Could this be the issue ??? But then, how come the under Variance % col is working perfectly well !!