9 Replies Latest reply: Nov 15, 2017 2:05 AM by Neil Gabin RSS

    Sum in ranges by a group category

    Neil Gabin

      Hi there

       

      I have expense lines loaded that group up into an Expense Reports (1 or more lines)

       

      I am currently showing the total amount in each of these groups using these expressions

      • Sum({$<[Expense Amount]={">=10000"}>} [Expense Amount])
      • Sum({$<[Expense Amount]={">=1000,<=10000"}>} [Expense Amount])
      • Sum({$<[Expense Amount]={">=100,<=999"}>} [Expense Amount])
      • Sum({$<[Expense Amount]={"<100"}>} [Expense Amount])

       

      2017-11-15_115510.jpg

       

      What I need is to do is add the total for each Expense Report in to one of the ranges listed above

       

      Neil