Expected a literal numeric value
This article includes suggestions and workarounds. Content may not be accurate for all use cases or represent best practices for the latest release.
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.