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.