#numberformat(queryObjectiveList.recordcount,"9,999")# Total Objectives
#numberformat(objectiveListCPTotal,"9,999")# Complete
#numberformat(objectiveListIPTotal,"9,999")# In Process
#numberformat(objectiveListARTotal,"9,999")# At Risk select sf.objQuotaHTD, sf.objAchievementHTD, sf.objAchievementPercentHTD, case when coalesce(sf.objQuotaHTD,0) = 0 then sf.objAchievementPercentHTD / 2 else ((cast(sf.objAchievementHTD as decimal)/cast(sf.objQuotaHTD as decimal)) + sf.objAchievementPercentHTD) / 2 end objAchievementIndexPTD, case when tf.weeksElapsed <= 26 then cast(tf.weeksElapsed as decimal) / 26 else (cast(tf.weeksElapsed as decimal) - 26) / 26 end timeElapsed FROM tbl_DW_ScorecardFacts sf with (nolock) inner join tbl_DW_Timeframes tf with (nolock) on tf.timeframeId = sf.timeframeId where sf.subjectId = and sf.subjecttype = 'usr' and sf.timeframeId = ( select max(timeframeId) from tbl_DW_Timeframes where ownerId = and ownerType = )

Objective Ach. Index, PTD	#numberformat(val(qryObjIndex.objAchievementIndexPTD) * 100,"99")#%
Elapsed Time, PTD	#numberformat(val(qryObjIndex.timeElapsed) * 100,"99")#%

#groupname#

#numberformat(objectiveCount,"9,999")# Objectives