Forum Discussion
Solved
Keep the value as Negative for specific records
I have a Table named "ICS_Transaction" in my SQL Database.
There is a column named "Net_Amt_LC" that shows the net amount of the transaction.
There is another column named "Voucher_Type" that shows a value 2021 for Credit Sales Transactions and 2023 for Credit Sales Returns.
The values in Net_Amt_LC are all positives. And I want to bring Net_Amt_LC values as negatives for all those transactions that has Voucher_Type = 2023.
Please help!
In Power Query, make a column:
NALCneg = [Net_Amt_LC]*-1
Then make another column:
NewNALC = if [Voucher_Type] = 2021 then [Net_Amt_LC] else [NALCneg]
1 Reply
jthomsonSolution Sage
In Power Query, make a column:
NALCneg = [Net_Amt_LC]*-1
Then make another column:
NewNALC = if [Voucher_Type] = 2021 then [Net_Amt_LC] else [NALCneg]