Query totals are not correct

[Former Member]

Hi All,

I have a report reporting on some calculated key figures with the following layout:

Plant Material Balance1 Balance2 Balance3

Please note Balance1, Balance2 & Balance3 are all calculated key figures based on some calculations like the following:

Balance1 is defined

( CKFBal > CKFSBal ) * Balance1

The key figures CKFBal , CKKSBal is hidden in the report.

Now for the following example:

Plant Material Balance1

1000 ABCCCC 10

1000 ABCC231 20

Total 85

Here Balance1 is displaying only records meeting the criteria defined above but the totals do not reflect what is displayed it is appearing to be adding what is not in the report being displayed. I tried few normalisation options like Query Result, Report result nothing seems to be giving the right result.

Kindly please share your inputs how I can get the report to show the totals of what is displayed.

Thanks

Karen

[Former Member · Accepted solution]

Hi,

Define a global calculated KF as beloow:

Balance1 =

( CKFBal > CKFSBal ) * Balance1 * Plant Reference Formula variable * Material Reference Formula variable.

Regards,

Anil Kumar Sharma .P

[Former Member]

Dear

Check for conditions if it is there because when we have conditions we will able to see the records but system include them in results.

So this may happen that you may not get proper results.

Regds,

Sachin

[former_member181964]

Hi,

Please try to change the Formulas properties in report, by right click and change.

Thanks

Reddy

[Former Member]

Hi Surendra,

What specific formula properties are you implying ?

Please clarify

Thanks

Karen

[former_member181964]

Hi,

In formual Balance1 you right click and then give Result as SUMMATION.

Thanks

Reddy

[Former Member]

Hi,

in Formula properties you select the following

1) Under aggregation tab, select Exception Aggregation = Totals and Referecne Characterstic = Material. ( if you want to calcualte totals at lower level, i.e material, or you can select something else depends on your requirement)

2) Now goto Calcualtions tab and select Calcualted Result As = Totals.

3) Now go to Advanced tab and choose 'Use Result of this formula'

You an play around with these options in formula properties until you get the desired result.

Hope this helps.

Praveen