Returning -ve values in 3rd columns with if condition

[rashid0146]

I have two columns one is SOP Type and other is Document Amount. I need a third column containing -ve Document Amount if SOP Type is Return other wise +Ve Document Amount

I Applied the following formula but result is +ve Document amount in Column 3.

Net sales = IF(SalesTransactions[SOP Number]="return",SalesTransactions[Sales Amount]*-1,SalesTransactions[Sales Amount]*1)

Please help me getting out of this.

Best Regards

Rashid Anwar

[v-huizhn-msft]

Hi @rashid0146,

I test it using my sample table, your DAx syntax is right, could you please share a screenshot for further analysis?

Column = IF(NewTable[Department]="Production",NewTable[Actual]*-1,NewTable[Actual]*1)

Thanks,
Angelia

[v-huizhn-msft]

Hi @rashid0146,

Have you resolved your issue? If you have, welcome to share your solution or mark the right reply as answer. More people will benefit from here.

Thanks,
Angelia

[v-huizhn-msft]

Hi @rashid0146,

Please add a parentheses around -1, and create a calculated column using the following formulas to check if it works fine.

Net sales = IF(SalesTransactions[SOP Number]="return",SalesTransactions[Sales Amount]*(-1),SalesTransactions[Sales Amount]*1)

Best Regards,
Angelia