Hi, I am trying to create a new row for the "maintenance" field and calculate rates based on the "maintenance" row? Is it possible?
OK, I see the issue, the maintenance rate is referenced in all rows. Try this:
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
@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
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?
