Skip to main content
Adaptive Insights
Knowledge and Support - Adaptive Insights

Formula Error: 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 form the formula, you will no longer receive the error.