Dynamic Output using Multi Row Formula

[bubblyjai1982]

Hi All,

Could you please assist on below.

I have certain records want to calculate the Net Amount based on below criteria.

If Account, Counterparty, Payment date is same then sum the Absolute amount otherwise NULL.

and then If Net amount = 0 then "No payment"
If Net Amount is Negative then "Receive from client"
(If Net Amount is Positive) otherwise "Payment to client"

Both input and output data is attached under different sheet.

Many Thanks,

Pavan

[binuacs · Accepted solution]

@bubblyjai1982 one way of doing this

[Yogesh1795 · Accepted solution]

Hi Pavan, if you need further help feel free to reach out

[bubblyjai1982]

Thank you Yogesh & Binuacs.

Both solution is same :)