IIf(([MasterResource-Query].ResourceType="Contractor",IIf(Month([MasterResource-Query].EndDate)<4 And Year([MasterResource-Query].EndDate)=2010,1,NonBillable_2010.April/(22*[MasterResource-Query].AllocationPercent))
IIf([MasterResource-Query].ResourceType="Intern",IIf(Month([MasterResource-Query].EndDate)<4 And Year([MasterResource-Query].EndDate)=2010,1,NonBillable_2010.April/(20*[MasterResource-Query].AllocationPercent))
IIf([MasterResource-Query].ResourceType="Employee",IIf(Month([MasterResource-Query].EndDate)<4 And Year([MasterResource-Query].EndDate)=2010,0,NonBillable_2010.April/(20*[MasterResource-Query].AllocationPercent))
IIf(Month([MasterResource-Query].EndDate)<4,1,NonBillable_2010.April/(22*[MasterResource-Query].AllocationPercent)))
)) AS AprilPercent