5 Replies Latest reply on Feb 6, 2019 4:05 AM by Zhouyi Zhang

    Conditional Formatting on Multiple Measure Values

    Ankit Shanker

      Hi all,

       

      I have created a simple report where I have taken two measure values i.e. Sum of Profits and Sum of Sales.

      I have created a calculated field called "Color" whose expression is SUM([Profit])>0

      My requirement is if I put Sum of Profit column in worksheet then it should display positive number as Green and negative as red.

       

      The problem is Sum of Sales Column is also affected by the same condition.

      I want normal black color font for Sum of Sales column.

      How to do that?