Distinct Sum

[Kwame]

Hi Guys!

I want to get a distinct total at the backend even after joining two tables, that is the bal total should read 1088 and not 4353.

The sample file is attached. Thanks.

[jochem_zw · Accepted solution]

see attachment