Forum Discussion

ganchevd's avatar
ganchevd
Helper I
8 years ago
Solved

Accounts Receivable Closing

Hello,   I am stuck in preparying an Accounts Receivable report by customer and by invoice. I have two columns "Invoice Amount" and "Closing Amount". What I want to do is to match the amount in the...
  • anandav's avatar
    anandav
    8 years ago

    Can you try a new column in Payments Table:

    IF (Payments_Table[Closed_by] IN Values(Sales[Entry_No]), Payments_Table[Payments],0)