Was there a new update to limit nested IFS() expression? I used the expression in a virtual column to perform sums based on multiple criteria. This worked without issue for over a year, then suddenly I now get this error:
"Your expression uses more levels of nesting than are allowed."
For better insight, here's how I used it:
IFS( [CsbfaLoanReg] = "Underwriter", 1.50) +
IFS( [CsbfaAppDoc] = "Underwriter", 0.65) +
...
IFS( [CsbfaLandlord] = "Underwriter", 0.65) +
IFS( [CsbfaDemolition] = "Underwriter", 0.65)
Please help.
LinkedIn
Twitter
