Defining data to be summed

If you sort payment transaction on date, you get one iteration per payment transaction in date order. If setting the property Is Grouped to true for the date parameter, you instead get one iteration per unique date. If you also have an amount parameter in that Restructure function, you get the amount for one of the payment transactions per unique date as default.

By setting the property Is Summable to true for the amount parameter, you get a summed amount for all payment transactions per unique date. In order to make this work, you must ensure that the linked input amount element always exists, that is not null, and contains a valid integer or decimal number. Otherwise, the mapping is terminated abnormally at runtime. There is no decimal rounding, or other number processing performed.