Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am looking to distribute participation in an object. I have been struggling build this table any clue?
Ob_ID | Owner | Participation (Expected expression) |
---|---|---|
12 | Alan | 0,33 |
12 | Joan | 0,33 |
12 | Laura | 0,33 |
14 | Alan | 1 |
15 | Sebastian | 0,5 |
15 | Laura | 0,5 |
Thanks in advance.-
Imediatly I posted the solution came up, here I share it:
participation = 1 / AGGR(NODISTINCT COUNT(DISTINCT Owner), Ob_ID)
Thanks anyway.-