5 Replies Latest reply on Aug 26, 2013 12:19 PM by DranLang

    Sum(PortalTableOccurence::FieldName) HELP!

    DranLang

      Title

      Sum(PortalTableOccurence::FieldName) HELP!

      Post

           Good morning everyone!  I have a portal that has a field (Amount) that I wanted to sum up all its values, but the formula I'm using won't add correctly it was just showing the first number of the values in the portal.  The field which I called DailyCost contains the formula for getting the sum of the the field (Amount) in the portal.

           The formula that I used is:

           Sum(COSTTABLE::Amount)

           The DailyCost will be added to another field which I called Previous and it will be in a field called TotalCost where I used the calculation:  COSTTABLE::Amount + COSTTABLE::Previous.

           And also, when I do the next day, the TotalCost value from the previous day will be the value of my Previous field.

           I tried using the GetNthRecord(COSTTABLE::TotalCost;Get(RecordNumber) - 1) but didn't work, is there something I forgot here or something that I need to change?

           Any idea, help is deeply appreciated.