Rounding problem

[#1]

Hi to all,

I have the following data:

group1	group2	group3	val
A1	B2	X	15,3451
A1	B2	Y	20,4511
A1	B2	Z	41,3983
A1	B2	W	22,8055
A1	B3	X	22,8756
A1	B3	Y	41,7893
A1	B3	Z	13,8733
A1	B3	W	21,4618

The sum of A1-B2 where group3 = X,Y,Z, W is 100 and the same for A2-B2.

I need to get the field val as an integer and still have the total to 100.

the result can be something like:

group1	group2	group3	val
A1	B2	X	15,3451	15
A1	B2	Y	20,4511	21
A1	B2	Z	41,3983	41
A1	B2	W	22,8055	23
A1	B3	X	22,8756	23
A1	B3	Y	41,7893	42
A1	B3	Z	13,8733	14
A1	B3	W	21,4618	21

Any idea to reach that?

Thanks!

[#2]

Hi use the CEIL function

...

NUM(CEIL(val, 0.1), '#.#00')

...