Data calculation using Formula tool

[soumya]

I am using a formula tool to claulate the spend. But there are certain rows for which I do not want it to calculate the cost. The way I can identify these line line item is becuase they contain a certain word. 

I am currently first calculating the spend for all and then trying to use a formula tool to make the spend 0 for only the lines I dont need spend for. How can I use a formula tool to say if my x coulmn containd "makegood" then make the spend 0? 

Not sure how to add this piece back into my workflow

[JohnJPS · Accepted solution]

Sure, just select the existing Spend column in the formula as your output field, and use the expression:

IIF([x]=="makegood",0,[Spend])

So basically Spend is updated to 0 when x="makegood" otherwise it is unchanged (updated to itself).

[soumya]

Thanks a ton! it worked :)