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

[arundaka02]

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: 

pod	ave steps
DH	35,847
MF	27,941
MW	10,263
Partner	29,954
VK	33,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

[AngelosPachis]

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

[Qiu]

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