Question Re: SAP Analytics Cloud - Formula Error: Function not allowed as a top level function in Modeler Formula in Technology Q&A

SAP Analytics Cloud - Formula Error: Function not allowed as a top level function in Modeler Formula

Former Member — Thu, 27 Feb 2020 02:43:33 GMT

Above is the error I encountered while adding formulas on one of my account measure in my model. My original formula is: TONUMBER( VAR_PY ).

VAR_PY is a date variable that lets the user choose a date period (in format of YYYYMM).

What does the error means? Thank you!

Re: SAP Analytics Cloud - Formula Error: Function not allowed as a top level function in Modeler Formula

mfoeken — Fri, 28 Feb 2020 09:09:20 GMT

Hi Denisse,

Did you try this on a copy of the account measure? What happens if you try the same in a story by creating a calculated measure?

Kind regards,

Martijn van Foeken | Interdobs

Re: SAP Analytics Cloud - Formula Error: Function not allowed as a top level function in Modeler Formula

Former Member — Mon, 02 Mar 2020 02:05:04 GMT

Hello Martijn,

Yes, I tried this on the account measure on the modeler. Thanks for the suggestion, I also tried this on the story itself and I noticed that the function works. I think the function only works on the story and not on the modeler. I'll close this thread now. Thanks.

Regards,
Denisse