If statement written

[priyarane]

Hi Expets,

How to write the below expression in our Script part.

First(IIf([Template]="Retail",[BaselII_Category] & " Pooled",[Cust_Name]))
If Cust Name is Blank,Null then Use Cust ID. If Cust ID is also blannk use Basel Category

Thank you

[sunny_talwar]

Not entirely sure what you mean when you say First? Are you looking for two if statements here?

Best,

S