2 Replies Latest reply on Jan 24, 2014 4:20 PM by symbister

    Totalling a filtered portal

    symbister

      Title

      Totalling a filtered portal

      Post

           Hi

           I have a layout with records from table 'Jobs' with a portal to 'Budgets'.

           Jobs::Job_No = Budgets::Job_No

           The portal is filtered to include certain budget items that have a tag set in the record.

           Budgets::Comms_tag = "x"  and Budgets::budget_amount > 0

           I'm trying to summarise the $ amounts from the budget items, for each job, using the same 'filter' as the portal, to give me totals on the layout... I've tried a number of permutations....just can't seem to get my head around it...

           each Budget record has Budget_Amount, Spent, and Budget_remaining fields

           so I want, for example, a total of Budget_Amount for those budget items that are tagged "x" for each job.

           any help appreciated

        • 1. Re: Totalling a filtered portal
          philmodjunk

               The following method produces a display only portal total. If you need to use this total in other calculations, a different method will be needed:

               In layout mode, make a copy of your portal and reduce the number of protal rows in this copy to 1. (By copying your portal, you get one the same width and with exactly the same filter expression.)

               Put a summary field defined in the portal's table to total the portal field from which you want this portal in the single row of this portal.

          • 2. Re: Totalling a filtered portal
            symbister

                 Excellent - thanks Phil