0 Replies Latest reply: Jan 7, 2013 8:52 AM by CJ Bell RSS

    Tabular form calculated summary row

    CJ Bell
      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