Column Subtraction

[sadath]

Hi,

I am trying to put a custom column by subtracting Value1 from Value2, Subtraction column is the result i got from PQ
Store3 result should be -21 (null-21) & Store 5 result should be 54 (54-null). How can get the correct result

Store Value1 Value2 Subtraction
Store 1 1700 3544 1844
Store 2 6464 2432 -4032
Store 3 21
Store 4 64 312 248
Store 5 54
Store 6 213
Store 7 654 1231 577
Store 8 56 2 -54
Store 9 3
Store 10 564 312 -252

 

[Learn Excel in Tamil]

Hi sady,
Hope your doing good!

if your look for Formula to do that please try with this formula "=IF((C3-B3)>0,(C3-B3),ABS((C3-B3))&" - null")"

Thanks!
LET

 

[sadath]

Hi
I wrote in my thread, its PQ (Power Query) not excel formula. And this section is only for Power BI

any one have the answer

 

[gazpage]

Nulls aren't the same as 0. A + null = null, a - null = null etc etc

Duplicated your columns for value 1 and value 2. Replace values null --> 0 and then do the subtraction. Delete the two helper columns.