5 Replies Latest reply on Apr 5, 2018 9:09 PM by Deepak Rai

    Summing over a rows with the same name(v10.5)

    Ryan Soares

      I have the dataset below showing forecasted and budgeted amounts for projects per month. What I want to do is determine the number of projects that are over budget, under budget, or equal to the budget over all the months. So for example for project A, I want to compare the sum of the forecasted amounts to the sum of the budgeted amounts to determine if this project is over, under, or on budget. The way I have it now, each row is treated independently, but I would like all rows with the same project name to be treated as one project.

      For this dataset, the desired result is: 1 project is over budgeted (A), 2 are under budgeted (C & D), and 1 is on budget (B).

       

      Any help is appreciated!