AnsweredAssumed Answered

Grand total portal rows

Question asked by Stu412 on Jan 6, 2015
Latest reply on Jan 6, 2015 by Stu412


Grand total portal rows


Hi there

I'm sure this has been asked 100 times before and I've been searching around, each time finding only half an answer...

What I have is a portal showing projects and how long each stage of a project will take, ie stage 1 = 1 hour, stage 2 = 3 hours, stage 3 = 23 hours.

I've added these up in my main table using a calculation to give me 9 hours on this project.  So far so good because all this sits on one row of a portal against one project ID.

When the customer has several other projects, I want to add up all the time against all the projects, ie, the row totals, to create a grand portal summary. 

That's where it goes pear shaped.

In the picture I've attached each row is a project and what I want to get in the grey area is a total showing '59 hours'

Hope that makes sense.