IF_Then malformed statement please help

[Dupuy]

Hello,

Can you help me with my condition loop please. It is impossible for me to close it.

Here is a capture:

For information, the column [package delivered within 3 months] is not a string.

Thanks in advance for your help.

[ShankerV · Accepted solution]

Hi @Dupuy 

This is because, the output is tried to store as VString.

But "appro" is String type, but when you do + floor(...)

Post that it is numeric type.

Please use "appro" + tostring(floor(...))

This will overcome the issue as it is converted to string.

Many thanks

Shanker V

[Dupuy]

Thanks SHANKERV, 

With your idea, my condition is good. But the result is not good because when I have 0 in my colomn "colis livré dasn les 3 mois", i need to have "appro SPCB " in the colomn "Appro PCB". But I have [Null] so it's mean my condition doesn't work. 

Do you have an idea ? 

Thanks in advance. 

Hugo

[ShankerV · Accepted solution]

Hi @Dupuy 

Please rearrange the formula like below.

Many thanks

Shanker V

[Dupuy]

Thanks Shanker v ! it's good !