5 Replies Latest reply on Oct 21, 2015 3:41 PM by DavidJondreau

    variable sum function

    malachydevlin

      Hi,

      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?

       

      thanks..