7 Replies Latest reply on Apr 21, 2016 5:16 PM by Jeff86

    How do I use the value from a Portal summary field in a calculation in the parent Layout's table?

    Jeff86

      I have a date range filtered portal showing a related table and I am summing the Total Cost field.  I would like to capture the value of the sum from the portal and use it to generate a calculated result for a file in another table (the layout's primary table).  When I do this using the Summary field from the related table (used in the portal), it adds the unfiltered Total Cost, not the date range restricted figure from the portal.  How do I capture and use the Sum of the Total Cost from the Portal, for the filtered date range only.  Thanks...