Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
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

 

 

5 REPLIES 5
Qiu
20 - Arcturus
20 - Arcturus

@pescobar11 

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

Qiu
20 - Arcturus
20 - Arcturus

@pescobar11 

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

Capturev3.PNG

mot
11 - Bolide

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
17 - Castor

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