Calculations with portal data.
Hello. I'm trying to do something that I think should be pretty simple and I've done before but I must be missing something. I have a portal showing various individual line items from one table. Each line item has an amount. I just want to be able to have a field in the parent layout to sum the total of these line items - and potentially do a bit of extra math later as well. For the life of me I can't get the sum field (in the parent table set to Sum ( PortalTable::amount ) to do anything but stay blank. As far as I can tell I'm doing everything I should but clearly I'm not. Please help,