This discussion is archived
0 Replies Latest reply: Jan 7, 2013 6:52 AM by CJ Bell RSS

Tabular form calculated summary row

CJ Bell Newbie
Currently Being Moderated
Hopefully this may be a quick question with either a yes or a no

I have a tabular form with columns

Project Name , Wk1 , Wk2 , Wk3 etc ,

basically so PM's can track the hours against a project

I have used the sum checkboxes to create a summary row

but they also want a row that calculates how many hours remaining for each week under the week no cols , obviously subtracted ffrom the hours budget for each week assigned to the project and person

I've done the summary and calculation in a view but this isn't acceptable as a UNION query in a tabular form

I've also tried another region under the Tabular form but as the project name is a variable length its not easy keeping the Wk cols aligned

thanks in advance

Chris

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points