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])




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