Skip to Content
avatar image
Former Member

How to display different measures in a table column based on a if else condition ?

Hi,

I'm very new to WEBI and am attempting to do a simple thing. I have a table and in one of its columns, I want to insert a condition to display a different measure for different dimension values. Here is what I've written:

=If([Sold To Area]="APAC"; [Incoming]; [Yesterday])

The table has two columns, Area and Incoming.So, whenever the Area is APAC (say), I want to display the measure [Yesterday]. When I write this, the else condition works, but the APAC row which is supposed to display the [Incoming] measure appears blank.

Any ideas on what I'm doing wrong here?

Thanks!

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Jun 29, 2015 at 03:25 PM

    Hi

    All three columns are coming from single webi query?

    Drag sold to area,incoming & yesterday in the single table and share the scrrenshot.

    Amit

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      =If([Sold To Area]="APAC"; [Incoming]; [Yesterday])

      The table has two columns, Area and Incoming.So, whenever the Area is APAC (say), I want to display the measure [Yesterday]. When I write this, the else condition works, but the APAC row which is supposed to display the [Incoming] measure appears blank.

      Accroding to your query you want to display [Yesterday] where Area is equal to APAC.if this iscorrect then your formula is incorrect.

      it shoud be like

      =If([Sold To Area]="APAC"; [Yesterday]; [Incoming])


      Amit