Forcing a whole number to be a decimal within script

[helen_pip]

Dear Qlikview User

I have field called Target which loads values in the following format:

95

85

75

etc.......

In the script I would like to convert the Target field to be in the following format

0.95

0.85

0.75

Is there a function or format I can use to achieve this

Kind Regards

Helen

[MK_QSL]

Target / 100 as Target

or

Num(Target/100,'#0.00') as Target

[Miguel_Angel_Baeyens · Accepted solution]

If that's always the case you can do as follows in the script:

Field / 100 AS Field

[Anonymous]

Load ...,

...,

Num(Target/100,'#.00') as Target

....,

from source