Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
NUm#(Sum(Qty))
it will help you
Channa,
Thank you very much!
it solved it,
do you know why this is happening?
Ido.