6.10.2

ZachChurch
ZachChurch
in Modeling

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

Tagged:

Answers

  • filip.sypniewski
    filip.sypniewski

    Hi @ZachChurch,

     

    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
    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).png2021-03-31 (13).png

  • jimfeng5
    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
    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.

Categories