Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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!

Tags:
Former Member
replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question