Skip to Content
0
Jun 28, 2020 at 09:34 AM

SAP Webi If Statement OR Where Clause

656 Views Last edit Jun 25, 2020 at 05:45 PM 3 rev

I am new to SAP, so I am not sure if this would be possible.

The table structure is like this:

I am trying to pull data into 2 separate columns from the same table. Some records have a [Journal Def] of ACH and others have [Land]. I am trying to pull the amounts for these rows independently based on an Entity_id.

For example, there are 1 row that have Entity_id = 1 with [Journal Def] = ACH and 1 row for Entity_id = 1 with [Journal Def] = Land. I want the amount summarized into one line like this:

In Webi, I pulled in the same column into the report twice and edited the formula in each. Here is the ACH formula

=If([Journal Def] = "ACH";[Amount];"0")

Here is the Land formula:

=If([Journal Def] = "Land";[Amount];"0")

Neither one of the pulled anything back and resulted in blank columns.... What do i need to do to fix this? I also tried creating a variable with this same forula and it did not work.

This statement also did not work:

=If([Journal Def]="Land";[Amount];If(IsNull([Amount]);0;[Amount]))

Any help is appreciated! Thanks.

***EDIT***

This formula sort of works. If it's null, it at least will put a "0" as the value, which is something that I want. However, if the value is not null, the value in the Amount column will not be pulled in.

=If(IsNull([Amount ]);0;If([Journal Def] = "ACH") Then ([Amount]) Else "0")

Attachments

wohoa.png (7.0 kB)
gf4is.png (6.1 kB)