Is there anything in FM 11 Pro Advanced that emulates Excel's SumProduct function?
How does SumProduct work in Excel?
Sums columns and rows in aggregate.
One way to sum the example below would be by putting c4*d4 in e4, and so on down the rows, then sum(e4:e6) in e7.
Sumproduct accomplishes that in one formula ..
Hummm, that's sums the products of the values in each row...
Does a "row" of your data represent one Record?
then the equivalent in FileMaker is to likewise do a two step calculation.
Use Sum (or a summary field) to compute the total of a calculation field. The calcultion field would compute the product of the fields of one record.
Retrieving data ...