Skip to main content

logoCorrectSize.png

Adaptive Insights LLC.

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. 

Explains how to correct the error returned by the formula assistant.

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.

  • Was this article helpful?