Auto format multiple numbers after dot

[idogridish2]

Hi,

the auto number format is showing a lot of numbers after the dot if i filter month field for "jan" and "feb" together,

please see attached pics, qvf and excel data, 

i would be very happy to know why this is happening i tried formatting with num(), round(),num#()

but it staid the same, only when i multiply it by rand() the format is displayed correctly/

thanks for any help in this issue.

Ido

[Channa · Accepted solution]

NUm#(Sum(Qty))

it will help you

[idogridish2]

Channa,

Thank you very much!

it solved it,

do you know why this is happening?

Ido.