Stimulsoft Business Intelligence System | Forum

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?)

Hello.

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

Thank you.

Got it sorted, Thank you

Hello,

You are welcome.