I would like to alternate the colours in a table based on the first column which contains a number as these lines belong logically together.
The background colour should be alternating between two colours to indicate which rows belong together.
So even/odd row is not working. Checking, if the previous row has another value than the current value using Above(field,1) does not work, because I need to toggle between two colours and cannot take a color based on the check.
This does not work in my case, because the a certain row might be missing due to a different selection, but the coloring should still be alternating. In my example table, I cannot assign a colour to a value (example 9 = grey), because another selection might make row value 3 not appear and then the value 9 should be coloured white because it would adjust to 2 which is already grey. I need a mechanism like:
if ((Above(col1,1)<> col1), toggleColor(), keepColor())