17 Replies Latest reply: Jul 3, 2017 8:54 AM by Andrey Khoronenko

# rounding of zero-values

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

• ###### Re: rounding of zero-values

Hi Beck,

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

=Sum(Value)*-1

Thanks,

Arvind Patil

• ###### Re: rounding of zero-values

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

• ###### Re: rounding of zero-values

Hi Beck,

Could you please share Sample qvw?

Thanks,

Arvind Patil

• ###### Re: rounding of zero-values

round(YourField,1) doesn't work?

• ###### Re: rounding of zero-values

Hi Beck,

Try

Div(Value, 1)

where Value = -0.07

Regards,

Andrey

• ###### Re: rounding of zero-values

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

• ###### Re: rounding of zero-values

I think I need some sample data...

• ###### Re: rounding of zero-values

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)  =)

• ###### Re: rounding of zero-values

May be

Can be at coloring to specify separately one of conditions, like this?

If(Value=0, Black())

• ###### Re: rounding of zero-values

Hi Andrey,

i will create my example with fake-values and show you

Thanks a lot

Beck

p.s: Spasibo Bolshoe sa pomosh i poddershku

• ###### Re: rounding of zero-values

Thank you for your kind words. :-)

Look attached file with example variant of coloring.

• ###### Re: rounding of zero-values

Thanks a lot Andrey

Spasibo Bolshoe

Beck

• ###### Re: rounding of zero-values

Was glad to help. Have a good day.

• ###### Re: rounding of zero-values

Hi,

try function fabs()