2 Replies Latest reply: Jun 28, 2018 9:43 AM by Dan Green RSS

    Have totals and % on bars

    Dan Green

      I'm using the barsPlus extension to get the values on the bar chart, but I was wondering if there was a way I could get the values to show percentages too. I'm assuming this would be in my expression and maybe with the dual fuction? The help page doesnt really give much detail on Dual() though. Any help is appreciated. Thank you!

       

       

        • Re: Have totals and % on bars
          Petter Skjolden

          Yes you should be able to use the Dual() function for that purpose.

           

          For example:

           

          Dual(1/2*100 & ' %', 34) will display as 50 % while the number part will be 34 just to show that the text part can be entirely different from the numeric part of a dual value.

           

           

          So in relation to to your expression it might have to look like this:

           

          Dual( Sum(Amount) & '  ' & Num(Sum(Amount)/Sum(TOTAL Amount),'0%') , Sum(Amount) )

           

          The only thing to be aware of is that the text part and the numeric part has to match up so that for every unique number there will be a unique text or it might not work as intended.