Return to FileMaker.com
Need Sum of field only if another field is true
I have a portal of values and Y/N field. I want to Sum the values, but only the values where Y/N field = Y. I can't seem to get a handle on the Calculation functions. Lemme write it in C and I'd be ok. :-)
There are several options for selectively summing data from related records
Here are two methods: Sum_Calculation based on condition
And then FileMaker 12 users can also use ExecuteSQL(): FMP 12 Tip: Summary Recaps (Portal Subtotals)
Retrieving data ...