5 Replies Latest reply: Oct 25, 2016 7:42 AM by Yeo Poh sai

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

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

• ###### Re: How to modify my expression to make -0.155 change to -15,5% ?

May be this:

=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)), '##.0%')

or

=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)) * 100, '##.0') & '%'

• ###### Re: How to modify my expression to make -0.155 change to -15,5% ?

Hi Sunny

I have try both your expression , it display null , it does not able to convert -0.3125 to %. ( I have reload to smaller file now the value have change from -0.155 tp -0.3125 )

Enclosed my QVW file.

Paul

• ###### Re: How to modify my expression to make -0.155 change to -15,5% ?

Try this:

=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))), '##.0%')

• ###### Re: How to modify my expression to make -0.155 change to -15,5% ?

!Hi Paul,

Try it

Regards

Miguel del Valle

• ###### Re: How to modify my expression to make -0.155 change to -15,5% ?

Hi All

Thank you both Sunny & Miguel help , now work fine.

Paul