Parse Error at Char(1)

Sach_J

Hey there!

I'm new to Alteryx so still finding my way around it all - wondering if I could get some guidance.

I'm getting the following error: "Parse error at char(1):unknown variable" for the following formula

I am certain that all the inputs are in a numerical data type

Thanks in advance !

Error Message

Parse

Accepted answers

atcodedog05

Hi @Sach_J

Adding to the above points. Another possibility is the field existing when workflow was built later field is missing. This is possible if the columns in input files changes. This is something to look into.

All comments

atcodedog05

Hi @Sach_J

This formula looks good. Just make sure the 1st column multiplier is getting supplied to the formula too. Can you share the error snapshot.

Emil_Kos

Hi @Sach_J,

What I like to do is using a bracket [ to make sure that I am using the right column names. At the screen below you see that you can pick the column names easily from the drop-down thanks to this.

like @atcodedog05 mentioned it looks like your column name might not be correct but the formula itself looks good.

atcodedog05

Hi @Sach_J

Sach_J

image.png

AkimasaKajitani

Regarding the screenshot, another expression may cause an error. Please check the 3rd expression.

Another possibility is that you may use the "Total Cost > NRV(USD)" field in another field that causes an error before calculating the "Total Cost > NRV(USD)".
Expression order is important.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703