5 Replies Latest reply: Oct 25, 2016 7:42 AM by PAUL YEO RSS

    How to modify my expression to make -0.155 change to -15,5% ?

    PAUL YEO

      Hi

       

      Below expression work fine :-

       

      =NUM(

      count(distinct(if(inv>'800000' and  inv<'899999' and CYTD,inv)))

      -

      count(distinct(if(inv>'800000' and  inv<'899999' and LY_YTD_Flag,inv)))

      )

      /

      count(distinct(if(inv>'800000' and  inv<'899999' and LY_YTD_Flag,inv)))

       

      it display as -0.155 , May i know how to make it display -15.5% ?

       

      I try below it does not work :-

       

      =NUM(

      count(distinct(if(inv>'800000' and  inv<'899999' and CYTD,inv)))

      -

      count(distinct(if(inv>'800000' and  inv<'899999' and LY_YTD_Flag,inv)))

      )

      /

      count(distinct(if(inv>'800000' and  inv<'899999' and LY_YTD_Flag,inv)))

      , '#.#%') &

       

      Hope some one can advise me.

       

      Paul