Multiple IIF Statements 1

[dodge20]

CRXI

Is it possible to have multiple IIF Statements such as:

iif ({UsrUsers.LoginName}="315" and {#RTotalDefinitionGross} >= 1589.68, {#RTotalDefinitionGross} * .015, {#RTotalDefinitionGross} *.01) 
iif ({UsrUsers.LoginName}="335" and {#RTotalDefinitionGross} >= 1319.83,  {#RTotalDefinitionGross} * .015, {#RTotalDefinitionGross} *.01)

Dodge20

 

[IanWaterman]

Never tried why not just use an if . then .else

if {UsrUsers.LoginName}="315" then
(if {#RTotalDefinitionGross} >= 1589.68
then {#RTotalDefinitionGross} * .015
else {#RTotalDefinitionGross} *.01)
Else
if {UsrUsers.LoginName}="335" then
(if {#RTotalDefinitionGross} >= 1319.83 then {#RTotalDefinitionGross} * .015 else {#RTotalDefinitionGross} *.01)

Ian

 

[dodge20]

Thanks IanWaterman

Dodge20