0 Replies Latest reply: Jul 25, 2017 2:24 AM by deepika vijayan RSS

    How to achieve Amount and Count format Pattern on same chart

    deepika vijayan

      Hi,


      I'm using an variable which as Count/Amount options, On click of count the data of the chart should be displayed in number format and on click of amount the data should be displayed in money format,based on number of digits the money format should change to cr(crore),l(lakh),..automatically ,  but the format pattern does not change accordingly.

       

      Below is the expression used in the chart:

      sum(if(vRF='C',RFCount,

      if(vRF='A',RFValue)))

      vRF is the variable name used for selection of amount or count option, C-Count and A-Amount.

      For reference Pfa .qvf file

       

      Thanks and Regards,

      Deepika