ATTAINED: IIf((IsNull([Actuals.PROJ_ACT_ID]) Or ([Actuals.ACT_PERC_COM]<=[Baseline.ACT_PERC_COM])),0,1)
So this either has a 0 or a 1 based on the condition. So in another query I did a simple SUM grouping on this column and it returns 22264. But if I pull the column into a spreadsheet, the number adds up to 92. What gives?