Need to add IF to Expression

Stimulsoft BI Designer discussion
Post Reply
MariusNel
Posts: 4
Joined: Fri Sep 30, 2022 6:16 am

Need to add IF to Expression

Post by MariusNel »

Hi I need to add this to expression or use in an variable, please help or give me ideas?

{IIF (Length(Trim(ActiveContractors.RATETYPE))> 0,
IIF(ActiveContractors.RATETYPE == "H",(ActiveContractors.BillRate - ActiveContractors.CostRate),
IIF(ActiveContractors.RATETYPE == "D",(ActiveContractors.BillRate/8)-(ActiveContractors.CostRate/8),
IIF(ActiveContractors.RATETYPE == "M",(ActiveContractors.BillRate/160)-(ActiveContractors.CostRate/160),
IIF(ActiveContractors.RATETYPE == "W",(ActiveContractors.BillRate/40)-(ActiveContractors.CostRate/40),0)))),0)}

or else I must assign this to Multiple expressions? (how please?)
Kirill Klimenkov
Posts: 18
Joined: Tue Mar 23, 2021 6:21 am

Re: Need to add IF to Expression

Post by Kirill Klimenkov »

Hello.

Sorry, maybe we did not exactly understand your question. Could you explain your issue in more detail?

Thank you.
MariusNel
Posts: 4
Joined: Fri Sep 30, 2022 6:16 am

Re: Need to add IF to Expression

Post by MariusNel »

Got it sorted, Thank you
Lech Kulikowski
Posts: 4973
Joined: Tue Mar 20, 2018 5:34 am

Re: Need to add IF to Expression

Post by Lech Kulikowski »

Hello,

You are welcome.
Post Reply