メインコンテンツまでスキップ
Adaptive Insights
Knowledge @ Adaptive Insights LLC, a Workday Company

Formula Error: Expected a Literal Numeric Value

Question

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?

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.

  • この記事は役に立ちましたか?