I was hoping to get some assistance with a formulas I’m trying to use that gives me an error in 2 of my levels. The formula I am adding is:
=div(ACCT.Units[level=5100],ACCT.Total_Units[level=Corporate Plan (+)])
The error I’m getting is: Expected a literal numeric value
I copied this formula from another formula in each level and changed the level modifier. I have done this previously and it worked. Why am I getting this error?
Typically, when someone receives this error, it is because the "=" sign is included in the formula. If you remove the "=" sign form the formula, you will no longer receive the error.