4 Replies Latest reply: Jul 25, 2011 3:28 AM by Martin FAVIER RSS

    How to show % values using class function

      Hi,

       

      i need  to show  in the class  function the values in % like 10% <=x< 20%.

      The formula that I use is:

       

      =class(round(aggr(count({<ID_FactSource={'ARIANNA'}>}distinct ID_FAT_DATA_FILE)

      /

      count({1<ID_FactSource={'ARIANNA'}>} distinct total ID_FAT_KEY_FILE), ID_FAT_C_Committente_Originale), .1), .1)

       

      I got the values like 0.1<=x<0.2 and so on.

       

      Any idea?

       

      Thanks!

       

      Andrea

        • Re: How to show % values using class function

          Hello,

           

          You can use the num() function, with your own number format (here, the %).

           

           

          num( 
          class(round(aggr(count({<ID_FactSource={'ARIANNA'}>}distinct ID_FAT_DATA_FILE)
          /
          count({1<ID_FactSource={'ARIANNA'}>} distinct total ID_FAT_KEY_FILE), ID_FAT_C_Committente_Originale), .1), .1)
          ,'# ##0%')
          

           

           

          Regards,

           

          Amand

          • Re: How to show % values using class function
            Martin FAVIER

            Hi,

             

            Amand was on the right way,

             

            But to be sure on your numeric format, I advise you to enter the last parameters (decimal and thousand separators) like this :

             

             

            num( 
            class(round(aggr(count({<ID_FactSource={'ARIANNA'}>}distinct ID_FAT_DATA_FILE)
            /
            count({1<ID_FactSource={'ARIANNA'}>} distinct total ID_FAT_KEY_FILE), ID_FAT_C_Committente_Originale), .1), .1)
            ,'#,##0.%','.',',')

             

             

            Hope that helps you,

             

            Martin