5 Replies Latest reply: Apr 2, 2015 4:20 AM by Manish Kachhia RSS

    values on data points loosing number format when located in the bar

    AC BC

      Hi all,

      I have a combo chart where the values of line and bar are overlapping, so I decided to plot the values inside the chart but when Iam doing this the money format with millions is lost and the bars are showing complete value.

       

      Any help??

       

      Thanks

      Kiran Kumar

          • Re: values on data points loosing number format when located in the bar
            AC BC

            Hi Manish,

             

            I have implemented a similar kind of solution but because the values may be thousands , millions, or billions I have created a parameterised variable like below

             

            if($1 < 1000, $1,

              if($1 > 1000 AND $1 < 1000000, $1/1000,

              if($1 > 1000000 AND $1 < 1000000000, $1/1000000,

              $1/1000000000

              )

              )

            )

             

            this is working fine for my problem but one of my expression is like this

             

            Sum({<QuarterYear={$(vCurrentQuarter), $(vLastQuarter1), $(vLastQuarter2), $(vLastQuarter3)}>}Spend))

             

            but when I am using that variable

             

            $(vNumConverter(Sum({<QuarterYear={$(vCurrentQuarter), $(vLastQuarter1), $(vLastQuarter2), $(vLastQuarter3)}>}Spend))) its not displaying any thing.

             

            I even tried dual , but to my strange the bars are displaying but the string value is for all bars is taking same.

             

            The expression which I have used is like this.

             

            if($(vNextQuarterButton)=1,

              dual(num($(vNumberConverter($(=$(vCurrentQuartersSpend(1))))),'#.00')&$(vNumberConverterSym($(=$(vCurrentQuartersSpend(1))))),Sum({<QuarterYear={$(vCurrentQuarter)}>}Spend))

            ,

              dual(num($(vNumberConverter($(=$(vCurrentQuartersSpend(2))))),'#.00')&$(vNumberConverterSym($(=$(vCurrentQuartersSpend(2))))),Sum({<QuarterYear={$(vCurrentQuarter), $(vLastQuarter1), $(vLastQuarter2), $(vLastQuarter3)}>}Spend))

              )

             

            In the above expression

             

            vNumberconverter :

            if($1 < 1000, $1,

              if($1 > 1000 AND $1 < 1000000, $1/1000,

              if($1 > 1000000 AND $1 < 1000000000, $1/1000000,

              $1/1000000000

              )

              )

            )

             

            vCurrentQuartersSpend :

            if($1=1,

              Sum({<QuarterYear={$(vCurrentQuarter)}>} Spend)

            ,

              Sum({<QuarterYear={$(vCurrentQuarter), $(vLastQuarter1), $(vLastQuarter2), $(vLastQuarter3)}>} Spend)

            )

             

            vNumberConverterSym:

             

            if($1 < 1000, '',

              if($1 > 1000 AND $1 < 1000000, 'T',

              if($1 > 1000000 AND $1 < 1000000000, 'M',

              'B'

              )

              )

            )

             

            num.png

             

             

            but the bar char is displaying same values, I think the string part in dual is not able to take dimension.

             

            The expressions were absolutely working for only this expression Sum({<QuarterYear={$(vCurrentQuarter)}>} Spend)

            without using dual.

             

            Thanks

            Kiran Kumar

          • Re: values on data points loosing number format when located in the bar
            Manish Kachhia

            Better to divide by 1000, 1000000 and use Symbols from Number Tab