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?)
Need to add IF to Expression
Re: Need to add IF to Expression
Hello.
Sorry, maybe we did not exactly understand your question. Could you explain your issue in more detail?
Thank you.
Sorry, maybe we did not exactly understand your question. Could you explain your issue in more detail?
Thank you.
Re: Need to add IF to Expression
Got it sorted, Thank you
-
- Posts: 5860
- Joined: Tue Mar 20, 2018 5:34 am
Re: Need to add IF to Expression
Hello,
You are welcome.
You are welcome.