Skip to Content
0
Apr 23, 2014 at 09:17 AM

Formula Variable - Key of Cost Element (Query crashing)

26 Views

Hi everyone,

I have created a formula variable which returns the Key of the Cost Element (0costelmnt) which resides in a Key figure structure. I have used this in a number of formula (If Cost Element = 50000 * (A * B) and its working fine.

Formula Variable Formula Variable Properties

My issue is that this query crashes constantlywhen you are in the Query Designer in both our Dev and Production environments, yet the query runs fine in the Analyser.

The only thing I note is the icons in the key figure structure, some squares which are standard key figures / formulas and formula variables but my Cost Element Form Vari and the Bonus and Salary Increase Formula variables are represented by a triangle which normally means characteristics!!

Any suggestions?

With thanks

Gill

Attachments

Form Vari.png (35.0 kB)
form vari prop.png (36.0 kB)
error message.png (38.3 kB)