Skip to Content
0
Aug 11, 2022 at 06:36 PM

Webi formula help

73 Views

Hi All,

I have the scenario below that I need help on creating a formula for.

Current Behavior:

image.png

Desired Behavior:

image.png

I would like to create a formula to add amounts from Code 'DEF' with the description 'Income' to Code 'ABC' only if Code 'ABC' is 0 or null. This example is seen for partner 1234 where the amount of 4000 is the same, but for partner 3333 and 2222, the amount from Code 'DEF' is added. As shown in the examples, there are also multiple entities that I would like this formula to apply to as well.

Any help will be appreciated.

Attachments

image.png (13.6 kB)
image.png (14.0 kB)