Reply
Highlighted
Regular Visitor
Posts: 31
Registered: ‎08-22-2018
Accepted Solution

Subtracting a column with condition

Hi!

i have a column A with 0 to 380 numbers in repeatred manner and another column X with Strings like Lower1,Outer1,Middle,Outer2,Lower2,Now i have to creat a column like  Column A values should subtract with 380 When they are equal to  Outer2 and Lower 2 of column X.PLease give me a idea how to over come this.

 

 

 

Thanks and Regards 

Javeed


Accepted Solutions
Moderator
Posts: 9,146
Registered: ‎03-06-2016

Re: Subtracting a column with condition

Hi @JAVED,

 

You can create a calculated column like below: 

 

Column = IF('Table2'[X]="Outer2" || Table2[X]="Lower2",'Table2'[A]-380,BLANK())

 

q1.PNG

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post


All Replies
Moderator
Posts: 9,146
Registered: ‎03-06-2016

Re: Subtracting a column with condition

Hi @JAVED,

 

You can create a calculated column like below: 

 

Column = IF('Table2'[X]="Outer2" || Table2[X]="Lower2",'Table2'[A]-380,BLANK())

 

q1.PNG

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.