5 Replies Latest reply: Feb 25, 2013 10:07 AM by dbuijsman RSS

    Postive and Negative value in Bar Chart

      Hi All,

      Please find the attached snapshot, Im displaying a BAR Chart with 4 Bar's where "Gold - Basic" and "Platinum - Gold" displays downward which is what I need and it is perfectly fine. But the value displayed there is shown as -1 instead I want the value to show me as 1 but still display the bar downward as shown in the attached image. Below is the expression I have used.

       

      If(Change='Gold - Basic',-Count(SUB_ID),if(Change='platinum - Gold',-Count(SUB_ID),Count(SUB_ID)))