I have the scenario below that I need help on creating a formula for.
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.