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

Question

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))

dougperez · Accepted Answer

Prueba esto: 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)))

fagoagaf · Accepted Answer

When I try re-running the workflow, I still get a parse error at char(605):malformed if statement (expression #1). I see that the error is tied to this section of your recommendation:

(
(
(
[Days at Integrator's Warehouse for Calc Period]-[days for higher rate]*(0.066/366)*[Unit PO Material Price]*[Qty for CoC]+[days for higher rate]*(0.095/366)*[Unit PO Material Price]*[Qty for CoC]
)
)
),0)))

fagoagaf · Accepted Answer

I also see this message:

Formula: tried to apply numeric operator to string value

dougperez · Accepted Answer

All these fields are numerical?

Maskell_Rascal · Accepted Answer

Hi @fagoagaf

The formula fix that @dougperez provided is correct. The reason you are still getting an error is because one of the fields in your formula is stored as a string and needs to be converted to a numeric type (double, int64, etc.). Once you correct this, the formula will work as expected. Just drop a Select tool on the canvas before the Formula tool and flip the data type over to Double.

Hope that helps

Cheers!

Phil