I am looking to return whichever is highest from the following;
Expr1: [Field A]*[Field B] or [Field A]*[Field C]
Any help appreciated.
I am looking to return whichever is highest from the following;
Expr1: [Field A]*[Field B] or [Field A]*[Field C]
Any help appreciated.
try
Expr1: [Field A]* iif([Field B]>[Field C],[Field B],[Field C])