Skip to Content
avatar image
Former Member

Formula in Webi dependant on 3 dimensions

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • May 09, 2017 at 02:57 PM
    1. variable_0 count ([Position0] where ([Position0]=0) In ([ID])
    2. variable_Print if variable_0 > 0 then Position_1 else position 0
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 12, 2017 at 06:40 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 18, 2017 at 12:34 PM

    Anyone knows how to do this?

    Add comment
    10|10000 characters needed characters exceeded