Skip to Content
0

Formula in Webi dependant on 3 dimensions

May 09, 2017 at 11:59 AM

79

avatar image

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

function.png (3.1 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Koen Hesters May 09, 2017 at 02:57 PM
0
  1. variable_0 count ([Position0] where ([Position0]=0) In ([ID])
  2. variable_Print if variable_0 > 0 then Position_1 else position 0
Share
10 |10000 characters needed characters left characters exceeded
Jacobsson Axel May 12, 2017 at 06:40 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Jacobsson Axel May 18, 2017 at 12:34 PM
0

Anyone knows how to do this?

Share
10 |10000 characters needed characters left characters exceeded