Help with Sum (By Group?)

[DSTaylor]

Hi,

I'm having an issue someone can hopefully assist with.

I have a table with the following fields:

Project Code,   Actual Hours,   Budgeted Hours

The total Budgeted Hours > total Actual Hours... however I need to figure out how to show in a text box the sum of Actual Hours > Budgeted Hours per Project Code.

So essentially across all Project Codes Budgeted Hours > Actual Hours.

There are a few Project Codes where Actual Hours > Budgeted Hours.

How can I just show these? I've tried 

sum(if(Actual>Budgeted, Actual) but of course this returns 0 until a Project Code with Actual > Budgeted is selected as otherwise it's calculating all and returning '-' as the total budgeted > actual across all codes.

I hope this makes sense,

Thanks!

[sumanta1234 · Accepted solution]

Hi,

you can use the below code:

=IF(AGGR(SUM([Actual Hours]),[Project Code])>AGGR(SUM([Budgeted Hours]),[Project Code]),AGGR(SUM([Actual Hours]),[Project Code]))

But still you have to select the project code then only you can see actual value in text object.