how to make 0.25 display as 25% ?

[#1]

Hi All

I have expression vSEG which is

=1-MARKUP_SUB

now display as 0.25

may i know how to make it display as 25%

Paul

[#2]

Enclosed my QV Doc

[Sokkorn · Accepted solution]

Hi Paul,

I have two method to do this job.

Method1 : vSEG =Num(1-MARKUP_SUB,'#,##0%')

Method 2: Keep your vSEG = 1-MARKUP_SUB

Right click on Input Box -> Property -> Number Tab -> Select Number and check Show in Percent (%)

Regards,

Sokkorn

[#4]

HI,

try with this:

NUM( YourExpression,'#,##0%')

[#5]

Hi SOK and other

Thank for give me 2 approach.

1 appraoch can , 2nd cannot as my list box have many field.

Paul

[#6]

Hi SOK

i though is not possible for 2nd approach , just try and found it work too.

Thank

Paul

[Sokkorn]

Hi Paul,

It possible, just select each variable and set number format accordingly.

Regards,

Sokkorn