6.10.2

When I try to add a formula to SYS07 it gives an error. check photo 2021-03-30 (1).png

Accepted answers

All comments

I can see that your dimension in the module is "----Employee Hierarchy----" (see under Applies To). Probably you have added that by accident instead of 'E1 Departments'. Your formula refers to the Code of element from 'E1 Departments' dimension, but it is not a dimension in this module and therefore the error.

Change the "----Employee Hierarchy----" as a dimension to 'E1 Departments' and it will be fine!

ZachChurch

I changed the Employee Hierarchy to E1 departments and it still gave me an error for some reason. When I look at pivot mode I have E1 department as one of the dimensions on pages. I don't know if that has anything to do with it. 2021-03-31 (14).png 2021-03-31 (13).png

jimfeng5

Hi Zach,
Your formula is showing "E1 Departments" where as your dimension is showing "E1 Department". There is an extra "s" in your formula. Hope this helps.

Jim

filip.sypniewski

Hi @ZachChurch,

you did it correctly! However, your dimension is called 'E1 Department' while in your formula you type 'E1 Departments' hence the error.

Quick Links

Can you help?

Unanswered questions

ADO Certification - Cannot Create Migration Link
Hi - I cannot seem to create a migration for Assignment 3 and it will not allow me to update the hierarchy and proceed further. It seems to think that a link has already been created, but I don't see anything. Any ideas?
How can i export accuracy metrics from Anaplan Forecaster to Model.
There was an error rendering this rich post.
A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…