2 Replies Latest reply on Sep 10, 2016 2:59 PM by Vishal D

    Conditional color of measure in text table

    Vishal D

      I have 2 measures Sales & Cost.


      I am then calculating Profit = Sales - Cost using a calculated field.


      How can I show profit with back ground color RED if its < 0 and GREEN if > than 0


      I am showing this data as text field.


      I created another calculated field IF([Profit])> 0 then 'Green' ELSE 'Red' END. Later added this field on colors mark. But its not working correctly