Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi use the CEIL function
...
NUM(CEIL(val, 0.1), '#.#00')
...