Please help sum of the the days between dates

building reports webintelligence
1

I have a report
Duration is the days between start and stop date
Propotion is the DURATION /TOTAL PROJECT DURATION
Designation ,startdate ,stop date, duration ,pROPOTION
A 1/1/2009 3/1/2009 59 1.5

A 2/1/2009 4/1/2009 59 1.5
B
c
now I have to get the result as
START DATE=min START DATE and stop date =max stop date
Here is how the table should look:
Designation ,startdate , stop date , duration, PROPOTION
A 1/1/2009 4/1/2009 118 3
The problem is when i sm the propotion as it is days between calculation I am getting wrong result or Multivalue error if I put sum(DURATION /TOTAL PROJECT DURATION)
:hb:

mahika :india: (BOB member since 2008-07-23)

2

You’ll get more attention to your topic when you give an appropriate subject. Please edit your post to change its subject.

Jansi :india: (BOB member since 2008-05-12)

3

Hi Mahika,
You can user FORALL for getting the desired result.

Regards
Bilahari

billu :india: (BOB member since 2009-11-09)