Skip to main content
Adaptive Planning
Last Updated: 2023-06-23
Expected Literal Numeric Values

Expected Literal Numeric Values

Question

I was hoping to get some assistance with a formula that 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?

Answer

Typically, when someone receives this error, it is because the "=" sign is included in the formula. If you remove the "=" sign from the beginning of the formula, you will no longer receive the error.