5 Replies Latest reply: Jun 12, 2017 3:45 PM by Audrey Fischer RSS

    Getting a Maximum budget - Sum by a category - Help

    Audrey Fischer

      Hello!

       

      I need a huge help.. I have the following data:

      Value SpentCategoryMax. for the Classification
      10.000HR50.000
      20.000HR50.000
      5.000Orange6.000
      2.000Orange6.000

       

      I need a way to calculate the overall spent X maximum.. in this case, I needed to get to:

      Spent: 37.000

      Maxium: 56.000

       

      The simplest way I thought of it was to do:

      Sum(Value spent)

      Sum(Max)/Count(Max)

       

      However, that doesnt work for the different values.. anyone has easy way to get the sum of my maximum value? I considered doing a Sum if for each category, but it seemed such a dumb way to do this.

       

      Thanks,

      Audrey