Need to add IF to Expression

[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]

Hello.

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

Thank you.

[MariusNel]

Got it sorted, Thank you

[Lech Kulikowski]

Hello,

You are welcome.