Hi ,
My set analysis setup based on month. quarter ,year. i am caluculating total usage based on FY. I am getting total usage wrong but if i select based on quarter the results are correct. Can any help with this please.
i used below expression for TOTAL
=num(((sum({<STAFF_TYP_CD = {'CV'}
,FTE_YEAR={'$(vCurrentFY)'}
,JOIN_DT=
,Month=
,PPED=
,CY_YEAR=
,FISCAL_YEAR=
,CY_YRMO=
,FY_YRMO=
,MonthYear=
>}TOT_HRS_USG)
+
sum({<STAFF_TYP_CD = {'CC'}
,FISCAL_YEAR={'$(vCurrentFY)'}
,JOIN_DT=
,Month=
,PPED=
,CY_YEAR=
,CY_YRMO=
,FY_YRMO=
,MonthYear=
>}TOT_HRS_USG))/2080)
,'###,###.###')
