rounding of zero-values

[beck_bakytbek]

Hi Folks,

i know, there are no a funny questions, but i have got a situation:

my value does look like: -0,07 , i tried to implement with the help of other functions like : Round and Ceil but i didn't achieve any solutions.

how can i round it to 0 (to zero without minus-sign)

Thanks a lot for your feedback and help

Beck

[arvind_patil]

Hi Beck,

Just Multiply Your Value by -1 You will get desire output.

=Sum(Value)*-1

Thanks,

Arvind Patil

[Anonymous]

round(YourField,1) doesn't work?

[beck_bakytbek]

Hi Arvind,

i tried that, but my value does look like (see attached screenshot)

as you see, if i round my values, some zeros have a minus-sign

Beck

[ahaahaaha]

Hi Beck,

Try

Div(Value, 1)

where Value = -0.07

Regards,

Andrey

[Anonymous]

try num() around your expression

[arvind_patil]

Hi Beck,

Could you please share Sample qvw?

Thanks,

Arvind Patil

[beck_bakytbek]

Hi Andrei and Robin

thanks a lot for your feedback,

all does work great, but i have any problem with my formula, if i try to implement the coloring, any zero are red, and some are black

Thanks a lot

Beck

[Anonymous]

I think I need some sample data...

[beck_bakytbek]

Hi Robin,

i create the example data and will show

Beck

p.s: i need a bit a time for example data because (wegen des datenschutzes)  😃