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

    Need help on comparing  2 calculations for conditional formatting


      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 ?