Round number when two digits after decimal is zero

[chaper]

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]

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 · Accepted solution]

Maybe like

LOAD

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

     ...

FROM ...;