How to get Balance from one Doc number with related invoices to the Document number

[tahreen371]

Hello All,

The Balance column should give a Zero if the Amount total is matching to the Payment total, else vice versa.

And also the total balance for the one Clearing Document Number  should be represented as marked in Red.

there multiple scenarios for reference in the attachment. 

Kindly help ASAP.

Regards

[tahreen371]

the balance i output of Column Amount and Payment. if Amount and Payment columns are same then Balance should be zero else remaining amount

[santhiqlik]

Try this to get balance:
Sum(Total <Clearing Document Number >Amount)-
Sum(Total <Clearing Document Number > Payment)

I have done this using pivot table with some sample data. 

Check the attached qvw. 

[tahreen371]

Gives error in expression

[santhiqlik]

What's the error... I have missed [] in column name.
Sum(Total <[Clearing Document Number] >Amount) -
Sum(Total <[Clearing Document Number]> Payment)