cancel
Showing results for 
Search instead for 
Did you mean: 

Formula Results on Aggregated Values doesn't make sense

Former Member
0 Kudos

Hallo Experts,

I have a BEx Query with a Processstart Date and a Process End Date, which are keyfigures in my Cube.

What I would like calculate the Processing Time, which is Enddate - Startdate. Which is working correct.

Not all processes actually have an enddate that is why i calculate the processing time only for the ended ones.

In addition i would like to calculate an average processing time, enddate-startdate / number of processes.

I am trying to do calculate an Average Processing Time.

Is there a way to calculate the formula on the aggregated levels instead of summing, or whatever aggregation behavior was choosen?

Regards

Daniel

Accepted Solutions (1)

Accepted Solutions (1)

former_member183777
Active Contributor
0 Kudos

Have you tried setting the calculate results as property to average?

Answers (1)

Answers (1)

Former Member
0 Kudos

You must create two calculated key figures for the Start and End dates and aggregate those first. I'm unclear what level of aggregation you're aiming for but you can use Exception Aggregation for this. Then you can average the difference of those key figures.