Also we're doing this (instead of taking the maximum value in the grouping set) because it's possible that your records have negative values in it, or maybe fractional values less than one. We're doing it this way because the sample tool used next doesn't have a 'Last N records' option. We're sorting the records by the sub-record ID descending to ensure that the last value is the first record we see. For every other row, look at the multiplication total in the row above and multiply it by the value in the current row.Īt this point we sort the records by the tiled field we created earlier () and then by the sub-record ID (). this only really applies for the first row in our dataset. Our formula checks and says then multiply 1 against the field value to keep it the same.

So, the first row in every group checks for 'Row-1', which doesn't exist, and so the above setting says that value is null. We have the group by set on the grouping fields, and set values for rows that don't exist to null. The multi-row formula tool is where we're actually doing the multiplication with One for each group, and then a record ID within each group. Thanks for listening You must be a registered user to add a comment. There are numerous 'work arounds', but a native product function built into the summarize tool would be great. I can currently count, sum, mean etc., but I cant multiply my data while grouping. The tile tool is creating two sets of record IDs. I would love to see a 'Product' option added to the summarize tool. 1) you want to do this across multiple groupsĢ) you may not know the number of values that you have to multiplyģ) there may be negative values in the multiplied valuesĥ) there may be fractional values less than one in the records.

Summarize tool alteryx