Correct syntax for IIF with 2 arguments

[Jennypi]

Hi,

I am trying to define IIF with 2 conditions. How am I supposed to write it?
I tried this:

Code: Select all

{IIF(Data.name.Substring(11,3)=="HF1",IIF(Data.important_data=="PARENT",Data.important_data,""))}

but I am getting this error :

"no overload for method 'iif' takes '2' arguments"

Should I use an "AND" operator?

Thank you for your help.

[Alex K.]

Hello,

Please check the following expression

Code: Select all

{IIF(Data.name.Substring(11,3)=="HF1", IIF(Data.important_data=="PARENT",Data.important_data,""), "")}

Thank you.

[Jennypi]

Thanks a lot!

[Alex K.]

Hello,

We are always glad to help you!
Let us know if you need any additional help.

Thank you.