Problem in set analysis

[#1]

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)

,'###,###.###')

[sunny_talwar]

The expression seems to look fine, do you have a sample to look into?