Turn Negative Numbers into Positive

Question

Hi,&nbsp;I have a column in a table called Account_Balances that I want to sum into table on a report.&nbsp; I have used the below to acheive this:CALCULATE((SUM(Report1[ACCOUNT_BALANCE])),Report1[ACCOUNT_BALANCE]&lt;0)&nbsp;However, because the source data is negative where the account balance is in credit, the total number is also a negative number.&nbsp; I am trying to turn that into a positive number on the report, but failing miserably.&nbsp;Here is what I have tried so far:1. Created a measure on source table with ABS(ACCOUNT_BALANCE).&nbsp; Then used the below formula:CALCULATE(SUM(Report1[ABSBalance]),FILTER(ALL(Report1),Report1[ACCOUNT_BALANCE]&lt;0))2. Tried inserting ABS( ... ) in various places within my original formula&nbsp;Whatever I have tried, the table on the report just goes blank.&nbsp; Any ideas what I am doing wrong?&nbsp;TIA,Dowsey

johnt75 · Accepted Answer

Try
Positive balance =
ABS (
    CALCULATE ( ( SUM ( Report1[ACCOUNT_BALANCE] ) ), Report1[ACCOUNT_BALANCE] &lt; 0 )
)

Forum Discussion

Turn Negative Numbers into Positive

2 Replies

Related content

Negative numbers in the brackets

Converting numbers from negative to positive

Date.AddDays not working with negative numbers

Graph positive numbers as negative

How to convert negative numbers into positive numbers