8 Replies Latest reply on Jun 4, 2015 5:54 AM by philmodjunk

    How to get Running Total in a Portal for a Specific Record

    PaulChan_1

      Title

      How to get Running Total in a Portal for a Specific Record

      Post

      Hi All,

      I need some input please:

      MainTable with each record having:

      MonthYear

      Field1- Number

      Field2- Text

       

      Relationship  to MainTable

      Portal filtered by Fiscal Year starting in April

      Running total within portal of Field 1

       

      How to get the running summary total number  field  in the specific MonthYear  row within the portal to be used in the MainTable to match the MonthYear record?

      Do I use GetNthNumber by another portal?

       

      Thanks in advance!!