Not Possible to use another dimension in Account Formula

[BilyanaK]

Hello all, 

I am trying set up formula for account calculation, but I am not able to use another dimension in the formula itself. The dimension name is correct, so I am not sure what I am doing wrong. Does anyone know how to resolve the issue? 

[MKreitlein]

Hello @BilyanaK 

Have you used the help functionality STRG + Space to check all available functions?

I know RESULTLOOKUP exists, but I doubt that LOOKUP exists ... at least not in my system...

BR, Martin

[BilyanaK]

Hello Martin,
thank you for your reply.  Tried out with REULTLOOKUP,  but unfortunately I still have the same error message: 

[MKreitlein]

Hello @BilyanaK
Have you also included the Dim_Profitcenter via STRG+Space or written manually?
It seems it should work... sometimes it is only one small space which creates the error ... just try another dimension for a moment, if this works.
BR, Martin