AnsweredAssumed Answered

variable sum function

Question asked by malachydevlin on Oct 21, 2015
Latest reply on Oct 21, 2015 by DavidJondreau

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..

Outcomes