6 Replies Latest reply on Nov 13, 2013 5:21 AM by ravi.vankayala

    Need help on comparing  2 calculations for conditional formatting

    ravi.vankayala

      Hi all,

       

      I have a requirement where i need to compare target value with actual value and show different colors.

       

      target value contains a number and actual value contains percentage numbers.

       

      Now i need to compare both and show some different colors based on the condition.

       

      problem i am facing is as we cannot mix aggregate and non aggregate functions i have added attr in target value calculation but i am not able to get correct value.

       

      any idea to compare both values ?