cancel
Showing results for 
Search instead for 
Did you mean: 

Formula For Total

sreenath_adapa
Explorer
0 Kudos

Hi Experts

Please go through the below Out put

Sales OffRating
A110
A25
TOTAL(10+5)/2

I need to show totals for the sales off as a custom formula(Total/Count)

But i don see any option for this requirement

so, please help me.

Thank's in Advance,

Sreenath.

Accepted Solutions (1)

Accepted Solutions (1)

anshu_lilhori
Active Contributor
0 Kudos

Hi,

I assume you are trying to calculate the average.For the same you just select the keyfigure--on the right hand side pane---hit the calculation tab---calculate result as Average.

Hope that helps.

Regards,

AL

sreenath_adapa
Explorer
0 Kudos

Hi Anshu,

Thank's for your reply i need to provide this out put for cognos

So local calculations will not work in Cognos,

Thank's

Sree

anshu_lilhori
Active Contributor
0 Kudos

Hi Sree,

You can make use of Exception Aggregation.

Make a new formula put your Rate keyfigure inside it and then hit -the aggregation tab ---Exception aggregation as Average ----Reference characteristic as Sales office.

This way your calculation can be used in other formulas and the value will remain unchanged even if you use the output as input in other tools.

Hope that helps.

Regards,

AL

sreenath_adapa
Explorer
0 Kudos

It's Working Fine.

Sreenath.

Answers (0)