Hi Rick,

I have data of some 900 odd obs. The total of that comes out to be 100k. Some of the values are upto 6 decimal places. The client wants the values to be up to 2 decimal places. but when I use a round function(round(var, .01)) or int function or ceil or floor function, the total is either less or more than 100k. is there any other function or multiple conditions i can use so that the total always comes out to be 100k. Thank you in advance.