Query Designer Formula Problems

[oddleif_rotmo]

Dear Colleagues!

I have a problem with making a formula in the query designer, I really do not know why this mistake appares, so I hope you can help me!

I have Key Figures in a Structure. They concist of amounts and different characteristics to separate them. I try to make a simple calculating formula to calculate the differnce between Budgeted and Actual amount. But the query designer tells me that the formula is not defined correctly!!

From the icon of the formula I can see that it looks more like a characteristic then a key figure. It has teh small f for formula, but the triangle is green and in front, while the grid is paled out and in the back... Does anyone have an idea what I am dealing with?!? Can this be a program error?

Hope you can help - Will sign points!!

Regards Silje

[Former Member · Accepted solution]

Hi Eric,

If you rightclick the error it will take you to that error.Now Just delete that formula and check for syntax,to ensure that formulae is with that particular object,Next create a new formula with required logic and check syntax ,....

Is it an standard query or custom created ??

KK

[oddleif_rotmo]

First to KK:

The right-click is not possible, the functions in the right-click meny are all greyed out. Instead of the usual error symbol there is a stop sign. When I remove the formula the query definition is correct, so I am sure of the root of the problem.

They are all in the same structure (only one) but have a complicated combination of calculated and restricted keyfigures saved globally.

I have now solved the problem by using the keyfigure itself, without calculating or restricting it first. I do not siplay the keyfigure but put it in to a formula where I use datafunction NODIM. Now it works in the formula as well!

Thank you for tips!

Silje

[Former Member]

is your calculated formula in the same structure as the other key figures, if not you will get that "characteristic" icon.

You can have 2 structures in a query but only one structure can contain key figures.