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")