KeyFigure Exeption aggregat problem

Hello,

I’m using a Key Figure, which in its aggregation tab I chose Exeption aggregat. as average(all values) and agg.referen.char as 0fiscper.

When I use a hierarchy and one of the nodes is an average of more than one period, it doesn’t sums all the averages for each node in the hierarchy. Instead it calculates all the nodes as an average of all the periods which where available (if there was no data in one of the nodes in that period it calculate the average of 0 and the node value)

I tried also to use the Exeption aggregat (of the KF) as AV0Avarage (value not ezual to 0) but its not working….

Please Advice,

David