topic Re: Round number when two digits after decimal is zero in QlikView

Round number when two digits after decimal is zero

chaper — Fri, 26 Jun 2015 14:53:40 GMT

I want to round the number during load when two digits after decimal are .00 if not don't round number.See below example

Thanks in advance

MK_QSL — Fri, 26 Jun 2015 15:00:21 GMT

Load

Product,

If(Frac(Value)>0,Value,Floor(Value)) as Value

Inline

[

Product, Value

A, 1.08

B, 12.00

C, 3.40

D, 6.00

E, 3.45

];

swuehl — Fri, 26 Jun 2015 15:01:27 GMT

Maybe like

LOAD

if(fabs(frac(Value)) < 0.005, Round(Value), Value) as Value,

...

FROM ...;