Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

StephCA
5 - Atom

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

 

Capture.PNG

4 REPLIES 4
KGT
12 - Quasar

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
21 - Polaris
21 - Polaris

@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 

0918-StephCA.png

StephCA
5 - Atom

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
12 - Quasar

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

 

screenshot_20240920_100125.jpg

Labels
Top Solution Authors