Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi - I have a straight table and like to check if the dimensional value matches the value above: I've looked at the Above() function, but this seems to be for expressions and not dimensional values.
Looking for something like this:
If (Person = Person on Previous Row, THEN Same, ELSE Different)
Eg:
| Row | Person (Sorted Alphabetically) | Dimensional Calculation |
|---|---|---|
| 1 | David | - |
| 2 | John | Different (to Row 1) |
| 3 | John | Same (as Row 2) |
| 4 | Johnathan | Different (to Row 3) |
| 5 | Steve | Different (to Row 4) |
| 6 | Steve | Same (as Row 5) |
Help appreciated
Jay
Thanks - I'll check it out and validate if its working against my dataset.
I am talking about Script
Thanks Anil / Tresesco - two great ways to get to my desired solution