I have some long expressions that I use in reports. Is it possible to assign the expressions to some sort of variable so when I have to use that expression in another expression it doesnt get too confusing. I tried naming it through properties but that didnt work. Example:
Expression 1 is =IIF(a<b, a=1, a=0)
Now in a new expression I want to use Expression 1:
Expression 2 is =IIF(IIF(a<b, a=1, a=0) AND (c<b), 12, 1)
Can I assign Expression 1 to become something like IIF(a<b, a=1, a=0) AS EX1?
Then Expression 2 is =IIF(EX1 AND (c<b), 12, 1)
Expression 1 is =IIF(a<b, a=1, a=0)
Now in a new expression I want to use Expression 1:
Expression 2 is =IIF(IIF(a<b, a=1, a=0) AND (c<b), 12, 1)
Can I assign Expression 1 to become something like IIF(a<b, a=1, a=0) AS EX1?
Then Expression 2 is =IIF(EX1 AND (c<b), 12, 1)
