Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Why is my IF statement malformed?

Carluccio555
9 - Comet

I literally copied a working formula tool from one workflow to another and now my if statement is malformed.

 

When I try retyping the expression from scratch I get this far:

 

 

image.png

then when I add the endif the expression shows as malformed:

 

image.png

 

Here is the exact same expression working fine in another workflow:

 

image.png

 

Am i missing somethin?

 

Thanks

 

 

2 REPLIES 2
TimN
13 - Pulsar

One thing to check is the data type of Forecast Amount in the second WF.

cjaneczko
13 - Pulsar

The formula looks fine. Check your data types, the Forecast Amount should be Double and your field that the formula is in should be a String format.

Labels
Top Solution Authors