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

You have two options and it's up to you to decide which is the better option:

You can format the field on the layout to just have two decimal places.

You can modify the calculation to be:

Round ( TotalPages /TotalTime ; 2 )

If this field is used in other calculations, the unrounded value will be slightly more accurate--don't use the round function.