Hi All,

I am wondering if there is a formula to accomplish this:

({Inv Total - LY} - {CN Total - LY}) / 6

Result rounded up to the nearest $1000.

Thanks,

Hi Susan,,

The ROUND(X, N) function can take a numeric value X and round it to the nears N decimal places.

If N is a negative number, then it rounds to the nearest whole number in factors of 10.

You would need ROUND(X, -3) to round X to the nearest 1000.

Awesome, thanks!

Every available function is described in the searchable F1 - Help for GridView.