Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI all,
I am trying to do MTD and PMTD but MTD is working an dPMTD is not working.
MTD:
NUm(Count({<"Calendar Month Num"={'$(vMaxMonth)'}, "Calendar Year"= {'$(vMaxYear)'}, TaskStatusNum= {'1'}>}SurveyTaskId),'#,##0')
variable : vMaxMonth = max("Calendar Month Num")
vMaxYear = max"Calendar Year")
PMTD:
NUm(Count({<"Calendar Month Num"={'$(vPreviousMonth)'}, "Calendar Year"= {'$(vMaxYear)'}, TaskStatusNum= {'1'}>}SurveyTaskId),'#,##0')
variable : vPreviousMonth= max("Calendar Month Num")-1
vMaxYear = max"Calendar Year")
Pls correct if m wrong
take a look at stevedark variables. need logic to cover prior periods that straddle multiple years, also need to cancel all other date selections in the set modifiers when manipulating through set analysis.
Strange. Syntax looks okay..