I've tried that - i think that works for integers if i'm rounding. Not rounding here it's more a number display issue. As a work around I've taken my current line item/1000 to give me the desired result. This would have to be done for every single line item - is there another way to do this ?
As u want to round of to 4 digits , you can use MROUND(x[, y][, r]) formula i.e. MROUND(Numeric line item[,Use 1000 as you want to round of to 4 digits] [, DOWN, UP, NEAREST (default), TOWARDSZERO, AWAYFROMZERO]) MROUND(numeric Line Item, 1000)