I have a data set that has hours projections for employees, as well as actual hours spent. I want to create a pivot table with a calculated field so that if there is actual data, it will ignore the projections and print that, but if there's no actuals, it will print the projections. For example, we now have actuals data for February and March, so it will print actuals for those two months and projections for the rest of the year.

Here is a simplified example of my data set:

Program
 Resource Feb-14 Forecast
 Feb-14 Actual Mar-14 Forecast Mar-14 Actual
Program A #1 100 100
Program A #2
160
 160
Program A #3 120 120
Program B #1 60 60
Program B #3 40 40
Program B #4 160 160
Program B #5 160 160
Program A #1 12
Program A #1 20
Program A #1 10
Program A #1 40
Program A #2 25
Program A #2 25
Program A #4 100
Program A #3 10
Program B #3 25
Program B #3 25
Program B #3 50
Program B #5 20
Program B #5 20
Program B #5 20
Program B #6 100


So I have separate actuals and projecteds columns, and I tried to create a calculated field in a pivot table that does =IF(ISBLANK('Feb-14 Actual'),'Feb-14 Forecast','Feb-14 Actual'). This always prints the actuals, though. I think the issue is that when the pivot table sums all of the nulls from the empty actuals, it comes up with zero (obviously), but is there a way to write this statement so that it will return the forecast numbers if the actuals are blank?

Thanks in advance for any help. This is my first time using this forum, so please let me know if I should provide any more information.