ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
2 Day Countdown - The Alteryx Community will be temporarily unavailable for a few hours due to scheduled maintenance starting on Thursday, April 22nd at 5pm MDT. Please plan accordingly.

Alteryx Designer Discussions

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

Multi-Row Formula Parse Error

pescobar11
5 - Atom

Hello,

 

Seeking help with an error with a Multi-Row Formula.  I can't for the devil in me figure out what is causing it.  I have a duplicate multi-row formula performing the same command with a slightly different "Aging" ([RM Aging]) and it works.  The syntax between these two are the same except the column it is calculating against, but even that is similar.

 

Any ideas?  Appreciate any help you can provide.

 

if [FG Aging]<=10 then '1-10'
elseif [FG Aging]>10 and [FG Aging] <= 30 then '11-30'
elseif [FG Aging]>30 and [FG Aging] <= 60 then '31-60'
elseif [FG Aging]>60 and [FG Aging] <= 90 then '61-90'
elseif [FG Aging]>90 and [FG Aging] <= 120 then '91-120' else '121+' endif

 

pescobar11_0-1614213643214.png

pescobar11_1-1614213687703.png

 

 

Qiu
17 - Castor

@pescobar11 

Can you check you "[FG Aging" field is numeric filed?

Qiu
17 - Castor

@pescobar11 

FG Aging column needs to be Byte, Int, or double to make it work.

Capturev3.PNG

mot
10 - Fireball

Hi @pescobar11,

 

I think if you use ToNumber([FG Aging]) where you have [FG Aging], it should resolve the issue. Let me know if it worked. Best.

grazitti_sapna
15 - Aurora
15 - Aurora

Hi @pescobar11,

 

Check for the Data type of your input. I agree with @Qiu, the type should be either Byte, Int or double for it to work. In my case it is Byte and I am not getting any parse error.

 

grazitti_sapna_0-1614236148005.png

I hope it helps.

Sapna Gupta
pescobar11
5 - Atom

Thank you all!

 

I will remember this solution for the future.  Appreciate the help everyone.

Labels