Subtract values within a column

Copper Contributor

Hi All,

 

I am trying to create a new column by subtracting values from a column grouped by their value. For example : New_column=A-B-C-D 

A=where status value is A

B=where status value is B

C=where status value is C

D=where status value is B

This is part of a bigger query which contains join and other conditions.

 

Thanks you.

0 Replies