cancel
Showing results for 
Search instead for 
Did you mean: 

Total Not Match

daniel_weisblut
Participant
0 Kudos

Hi

need your help

We have a Problem With the Total

And for some reason the total does not sum up the components below it

Can't figure out why it's not working

I am attaching the example:

As you can see the Total Not Match

Net_Sales is calculation :

Net sales - PlanT

we build it for choosing the year by filter

Look at the report

We duplicate the number by items PlanY = FY

There no change in the items but the total is on +0.9%

Accepted Solutions (0)

Answers (7)

Answers (7)

daniel_weisblut
Participant
0 Kudos

I understand but this a problem

I wanted to show the products by hirr but if the calculation is not good perhaps i will do flat presentation and see if its calculate correctly (hope so)

Is there a way to open a ticket on that to SAP?
The hierarchy should show a weighted average in all its levels and not a simple average at the mid levels and different calculation in the all level

Thank you for all the help

daniel_weisblut
Participant
0 Kudos

Hi Nikhil

Good News and Bad News

The good news that The calculation of average net_price is correct in the higher level

BUTTTT!
In the level 2 at the Hirr The calculation is not correct

Its calculate regular Avg

N1kh1l
Active Contributor
0 Kudos

daniel_weisblut

You cannot have 2 rules for calculation at nodes. Either it can be sum of children or it has to be calculated at parent node ( Quantity * net Price ). This applies to all level of parents.

Br.

Nikhil

N1kh1l
Active Contributor
0 Kudos

daniel_weisblut

Try changing the Exception aggregation of Net_Sales to SUM and keep the exception aggregation dimension as product and see if it works. This way you would not need the extra aggregation measure to get the correct total and Net_sales will also support planning.

Br.

Nikhil

daniel_weisblut
Participant
0 Kudos

Hi

Thank you very much for the quick respond and for the examples Apricate you help

I have to say that its surprised me that i cannot just use hirr or to show totals in the story

and for each version (actuals / forecast / planning etc) i will need first to build Agg measure and then restricted measure

And the Big Problem is that the new measure by Agg is not open for planning

I am trying to understand what i did wrong in the model that causing that

Apricate Your help we have a presentation of the system to a customer

N1kh1l
Active Contributor
0 Kudos

daniel_weisblut

daniel_weisblutI recreated your example.

Net sales:

Net sales Aggr ( gives correct Total)

Net Sales Plan ( Restricted Net Sales Aggr )

Br.

Nikhil

daniel_weisblut
Participant
0 Kudos

Hi

We did Your Idea

The problem is Agg in not open for Planning

I cant show the customer 2 columns one for planning with wrong result and 1 for sum

Can I share with you the model and the story

N1kh1l
Active Contributor
0 Kudos

daniel_weisblut

I think its a aggregation issue for Net_Sales. Can you just create another measure of type aggregation and use the measure Net_Sales in it and keep the aggregation as SUM. Use this new aggregation measure in report and check if the Total is correct or not ?

Nikhil