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