Skip to Content
0
Former Member
Apr 09, 2010 at 09:30 AM

How to apply Formula for the overall result also

37 Views

Hi ,

I am working on BI 7.0 system and working on a reports and requirement is like

closed date(char) type date

created date (char) type date

NO of complaints (KF)

AGE = formula (closed u2013 created)

(Created the two formula variables using the replacement path)

I have created another formula i.e. average time = age / no of complaints

In the rows maintained the created date and closed date

In the columns maintained the age and average time.

I am getting the output correctly but that same formula has to apply for the overall result also.

Created date closed date age complaints average time

x x 84 1 84.0000

x x 83 11 7.5455

x x 82 2 41.0000

Overall Result 249 14 132.5455

The average time 132.5455 is wrong it should be 249/14 = 17.7857

I tried all the setting in the formula tabs like aggregation and calculations.

Please advice me to resolve the issue. Thank you very much for the advances for the help.

Cheers,

visu