Multiplying a value if the value is on or over a certain value

Question

Hi everyone,

In the attached dataset 'Pod Steps on and after 13.02', I want the sum_steps value to be doubled if the value is on, or over, the ave steps value in the table below:

podave stepsDH35,847MF27,941MW10,263Partner29,954VK33,859

For example, if DH pod record 36,000 in sum_steps then it should change to 72,000 as it is over 35,847. If the value does not go over the ave steps value, then the number remains the same.

Assuming a conditional statement in Formula tool will achieve this but my attempts haven't gone to plan!

Any help appreciated, thanks

KA

Pod Steps on and after 13.02.xlsx

Qiu · Answer

@arundaka02 
As suggestd by @AngelosPachis , I tried with the Joint Tool

0314-arundaka01.yxzp

AngelosPachis · Answer

Hi @arundaka02 ,

I've used a find & replace tool to append the ave steps field right next to each sum_steps field based on the pod. Then with an If expression, I estimated the required Sum_Steps. You can achieve the same with a Join tool as well.

Hope that helps,

Angelos

example.yxmd