Calculated column for getting ABS Value

Hello,

Can anyone help me with the below scenario. Not able to get get the proper absolute values when doing a difference of values between two columns.

Column A

Column B

Column C

Column D 

Coumn E = Column B+Column C+Column D 

Column F = Column E - Column A

ABS Column F = ABS(Column E - Column A)

Sample data structure:

If i create a measure the values are coming as expected but not with a calculated column. I cant use a measure because i have to use calculated column in a matrix which has the show data points as a table option, which only appears if i use a calculated column.

So please help me how should i write a calculated column to get the correct abs values.

I tried to even do something like IF <0 THEN *-1 ELSE *1 on column F but it is not giving the proper results, my data is very granular i.e many transactions for a customer and i am not able to figure out how the results are computed at calculated column level to tweek the code

Appreciate if someone can help me with this

Thanks!