IIF formula

Stimulsoft Reports.WEB discussion
Post Reply
laducd
Posts: 115
Joined: Thu Oct 23, 2014 2:15 pm

IIF formula

Post by laducd »

{IIF(cq1.TradeDescription=="CAPITAL LEASE",(cq1.Pre_Swap_Debt_Total/Capital_Lease.Post_Swap_Debt_Total_Sum)*cq1.Post_Total_IRS_Rate2)}

Is there anything wrong with this if formula
Jan
Posts: 1265
Joined: Thu Feb 19, 2009 8:19 am

Re: IIF formula

Post by Jan »

Hello,

You skip the third argument of IIF function. What you need:

{IIF(condition, variant1, variant2)}

You have only variant1.

Thank you.
laducd
Posts: 115
Joined: Thu Oct 23, 2014 2:15 pm

Re: IIF formula

Post by laducd »

can you jump on a call
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: IIF formula

Post by HighAley »

Hello.

Do you have any issue with IIF() function?
Please, write us to support@stimulsoft.com.

Thank you.
Post Reply