I have Estimated Budget hours (ie 800) and then sometimes we Update our hours (ie 3,600) to a new "Updated Budget" if needed. (This "update budget" is set up to include the original estimate so I cannot simply add them) I need a column to combine using the Updated Budget hours except when ' ' empty or 0, then use the hours in the Estimated Budget.
I do know the Updated Budget is ' ' (empty) See attachment
I have tried this:
SELECT processimprovement_dwb. *,
Case WHEN `Updated Budget` like ' ' then (`Estimated Budget`+`Updated Budget`)
else `Updated Budget`
end as 'Estimated and Updated Hours' from processimprovement_dwb
And I have tried this:
SELECT processimprovement_dwb. *,
Case WHEN `Updated Budget` like '' then (`Estimated Budget`+`Updated Budget`)
else `Estimated Budget`
end as 'Estimated and Updated Hours' from processimprovement_dwb
But neither one gives me the result I need.
I need to see the value for the Estimated Budget where there was a 0 for Updated Budget.
Please see attachment.