Help with Dax formula to deduct or subtract based on sign

[QuantumLP]

I have a data set for my finance department in which I have a Total over due column which can be positive or negative amount, and a Vendor blance which can also be positive or negative amount.

I need to create a measure which gives me the net from both values, but if I try a subtract, it will add negative amounts together.

My measure currently looks like this

Net Receivable = CALCULATE(SUM(CustomerLedgerEntries[AGE_TotalOverdue])-SUM(CLE_byCx[Vendor_Balance]))

Howver due to the value sin both columns sometimes being negative or positive it does not give me the net between the 2 columns.

Any help would be appreciated

[amitchandak · Accepted solution]

@QuantumLP , not very clear

you can try

Net Receivable = CALCULATE(Abs(SUM(CustomerLedgerEntries[AGE_TotalOverdue]))- Abs(SUM(CLE_byCx[Vendor_Balance])) )

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[QuantumLP]

This did the trick! thanks so much!