Invoice Spreadsheet - Aggregate Sum function

Summary:

The Aggregate sum function in the invoice spreadsheet doesnt seem to be working fine. Wanted to check if the below syntax was correct.

Content (please ensure you mask any confidential information):

Requirement is to sum the line amounts amounts as one of the conditions. Have used the aggregate sum dialog box to populate the syntax but the rules do not seem to get picked up based on the amounts

Invoice Distribution.Amount : between 0.00 AND 140000000.00; Where : { Line Type : in(ITEM, FREIGHT, MISCELLANEOUS) }

Invoice Distribution.Amount : between 140000000.01 AND 280000000.00; Where : { Line Type : in(ITEM, FREIGHT, MISCELLANEOUS) }

Version (include the version you are using, if applicable):