Formula in Webi dependant on 3 dimensions

[jacobsson_axel]

Hello, can someone please give me a hint on how to do the following:

For each ID, If Position 1 is null then show Result from Position 0, else show only Result where Position is 1.

This is easy to do except the rows i individual, showing both Pos 0 and 1, i need something that compares; for each ID, is there a null value at Position 0? In that case, print Result from Position 1.

Regards, Alexfunction.png

[jacobsson_axel]

Anyone knows how to do this?

[jacobsson_axel]

Thank you, i realised i missed a vital step, what i really need is:

For any number of rows within the same ID;

If Result is null where Position is 1, then print Result where Position is 0. Else Result where Position is 1

Regards

[kohesco]

1. variable_0 count ([Position0] where ([Position0]=0) In ([ID])
2. variable_Print if variable_0 > 0 then Position_1 else position 0