Total of Table lookup fields in multi record portal.
Brand new home user licensee of FM13. I have gone round in mental circles on this. The answer must be so simple!!
An individual's contact layout contains a portal that lists number of classes booked by that individual on a given day. The cost for each class in the portal comes from a Class Table look up. I want to sum the total of the class costs for that day and display it on the individual's contact layout. I've tried every option I can think of but am missing something very basic.