after decimal point values without round off

[ArjunPrasad]

Hi All,

i have a Id and value column in table , trying to do truncate the values after decimal with using below expression

Dim: ID

expression: Floor(Sum(Value),0.01), with this i am getting expected values for Positive values,

but for some netagative values getting rounded off as shown below image

from below image let say value -107.9667 should show -107.96  but showing 107.97

.

please find attached datasample and suggest the solution.

Thanks in advance

Arjun

[MayilVahanan]

Hi Arjun,

For negative values, you can use ceil() instead of floor(), it will helps you

[ArjunPrasad]

Thanku for reply Mayil

with Ceil expression negative value coming as expected but Positive value not coming as expected.

[MayilVahanan]

Hi Arjun,

Try like below

If(Sum(Values)<0, ceil(), floor())

[ArjunPrasad]

Hi @MayilVahanan 

it almost all values are showing fine but for one value its not showing as expected ,its a strange i dont know why

plz find attached excel in that

ID= 497647238 value is -135.2  for this it showing -135.19 it should show -135.20

Plz suggest

Thanks,

Arjun