Data is incorrect when remove drilldown characteristic

[former_member372884]

Dear Experts,

     I create query as figure below. Formulas are used to get results. The red outline is the value of curriculum group which is the summation of the curriculum of that group.

     But if I remove curriculum, show only curriculum group, the result is not equal the value in the first figure. BEx recalculates the result according to the formula in query designer. Is there any way to calculate the result as summation, regardless the formula?

Thank you in advance

[former_member372884]

Hi Suman and seshu,

Thanks for your answers but it still doesn't work. Any more suggestions?

Thank you.

[former_member182470]

Try "Calculate Result as" Nothing Defined for your KF.

[former_member199945]

Hi,

Change  both kfg properties calculate Result as Summation and Total and check once, if it not works in advanced tab "Use Result of Competing Formula" as suggested by Suman.

Thanks.

[former_member182470]

You can select "Use Result of Competing Formula" in Advanced tab of your Formula KF.