11 Replies Latest reply on May 11, 2010 11:55 AM by storywizard

    portal rows total then divide

    storywizard

      Title

      portal rows total then divide

      Post

      Hello:

       

      I have a portal where I have a column of  figures  that I total, giving me Total Time, then I want to divide that total by another figure, not a calculation field.My portal row is totaled using a caculation field. 

       

      This is how I get to the total of my tme fields.

      Field in zTasks called : Amount (text field)

      Field in zTasks called : zPages (Calculation Field)  Sum (zTasks::TimeSpent)

      Field in zTasks called : TotalTime (Summary Field)

       

      I cannot figure out how to start from the initial data in the portal rows, total them then divide by another field, which is not a calaculation field.

       

      Hope that is clear...

       

      S