7 Replies Latest reply: Oct 12, 2018 6:03 AM by Miguel R RSS

    How to show value on the same row?

    Miguel R

      Hi Guys,

       

      Would be nice if you could help me out. How can I show value on the same row?

       

      I have two tables, Table 1 and Table 2 on the backend. On the front end I have a filter on "Level" (see underlying picture)

       

      On the front end I selected Level = A, and Type = Bad ----- This should show a ranking lower than A. So in this case, 2 which is equal to B.

       

      My current if statement is working for 'Good' but for 'Bad' I cant find the right solution. I'm getting ranking 2 and would like to show B.

       

      My current statement is the underlying, I tried playing with variables to get the B but it is not working.

       

      IF(Type='Good',[Level],IF(Type='Bad',Rank+1)) as Test

       

      Community Question.PNG

       

      Do you guys have any idea?

       

      Thanks in advance.