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

    portal rows total then divide



      portal rows total then divide




      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...