Help with creating a row and calculate amount based on the row added

[StephCA]

Hi, I am trying to create a new row for the "maintenance" field and calculate rates based on the "maintenance" row? Is it possible?

[KGT]

Yes it's possible.

Text Input with the maintenance row

Union that on to your data

Formula tool to work out the rates: IF [Service]="Maintenance" THEN <insert formula> ELSE <insert formula> ENDIF

[Qiu]

@StephCA 
I have made a quick sample for your reference.

I use the formula tool but maybe the Text Input tool is better as suggested by @KGT 

[StephCA]

Thanks for that. I replaced the first step with the text input but now I'm not sure how the calculations would work without the Cat1 and Rates1 column. Any idea?

[KGT · Accepted solution]

OK, I see the issue, the maintenance rate is referenced in all rows. Try this: