QTD Systax Issue :

[#1]

Hi,

I 'm facing some wierd issue with QTD...Is there anything wrong in my syntax...Appreciate your help

if(wildmatch(only({1}CATEGORY_LABEL_SORT),20.5,24.5,21,0),'', Sum({$<PeriodID = {"<=$(=Max(PeriodID))"},QuarterID={"=$(=Max(QuarterID))"},FISCAL_YEAR=,FISCAL_QUARTER=,PeriodID=,PROJECT_NAME=>} DOLLAR_AMOUNT))

[Nicole-Smith]

Maybe try:

if(wildmatch(only({1}CATEGORY_LABEL_SORT),20.5,24.5,21,0),'', Sum({$<PeriodID = {"<=$(=Max(PeriodID))"},QuarterID={"$(=Max(QuarterID))"},FISCAL_YEAR=,FISCAL_QUARTER=,PeriodID=,PROJECT_NAME=>} DOLLAR_AMOUNT))

I removed the = from {"=$(=Max(QuarterID))"}.

Also, what do PeriodID and QuarterID actually look like?  Are they numbers that you can use max() on?

[#3]

     ((FISCAL_YEAR-1)*13) +FISCAL_PERIOD AS PeriodID,

     ((FISCAL_YEAR-1)*4) +FISCAL_QUARTER AS QuarterID,

[#4]

Still i'm not getting an expected result...If we have two years 2013,2014...If the user clicks on 2013 Q3,it is showing all the data including 2014.

[Nicole-Smith]

Can you post a .qvw?  I can't tell what's not working without actually seeing it.