In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Parse Error at Char(603): Malformed If statement (Expression #1)

fagoagaf
6 - Meteoroid

I need help in fixing an error I'm seeing. Can you provide guidance?

 

iif([Total Days at Integrator's Warehouse]<=30,
[Days at Integrator's Warehouse for Calc Period]*(0.XXX/366)*[Unit PO Material Price]*[Qty for CoC],
iif([Total Days at Integrator's Warehouse]>30 and [Total Days at Integrator's Warehouse]<181,
[Days at Integrator's Warehouse for Calc Period]*(0.XXX/366)*[Unit PO Material Price]*[Qty for CoC],
iif([Total Days at Integrator's Warehouse]>=181,
((([Days at Integrator's Warehouse for Calc Period]-[days for higher rate]*(0.XXX/366)*[Unit PO Material Price]*[Qty for CoC]+[days for higher rate]*(0.XXX/366)*[Unit PO Material Price]*[Qty for CoC]))),0))

10 REPLIES 10
fagoagaf
6 - Meteoroid

 Thank you so much for the help!!! Both of you really helped me solve something that was giving me issues.

Labels
Top Solution Authors