I was hoping for some pointers here.
I need to sum up the values in a portal (related table) but the sim function will only give me all the rows summed up.
I was looking for the sum of all the values based on a condition.
e.g all the totals of the related records where the status is "complete", only a sample.
I can achieve this with an execute SQL and the sum function on a where clause but i prefer to use fm functions if one exists?