Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm using this set analysis formula, however it's ginving no result.
If(sum(CountOf_Questionnaire_number)>=100,Sum({$<Yearmonth={$(=Date(AddMonths(Max(Date#(Yearmonth,'YYYY MM')),-2),'YYYY MM'))},Yearmonth={$(=Date(AddMonths(Max(Date#(Yearmonth,'YYYY MM')),-1),'YYYY MM'))},Yearmonth={$(=Date(AddMonths(Max(Date#(Yearmonth,'YYYY MM')),-0),'YYYY MM'))},Yearnumber=,Monthnumber=,Quarter_code=,Bookyear_code=,Bookyear=,Monthname=,Quarter=,Quater_name=>} Satisfaction_Score)/Sum({$<Yearmonth={$(=Date(AddMonths(Max(Date#(Yearmonth,'YYYY MM')),-2),'YYYY MM'))},Yearmonth={$(=Date(AddMonths(Max(Date#(Yearmonth,'YYYY MM')),-1),'YYYY MM'))},Yearmonth={$(=Date(AddMonths(Max(Date#(Yearmonth,'YYYY MM')),-0),'YYYY MM'))},Yearnumber=,Monthnumber=,Quarter_code=,Bookyear_code=,Yearmonth=,Bookyear=,Monthname=,Quarter=,Quater_name=>} pond),'Obs < 100')
However this part
=(Date(AddMonths(Max(Date#(Yearmonth, 'YYYY MM')), -3), 'YYYY MM'))
Show correctly 2011 01
I've looked at it for a while, but I can't seem to find out what's causing the problem here.
Best regards,
Arjan
And alsi with the simplified formula it's not working..
If(sum(CountOf_Questionnaire_number)>=100,Sum({$<Yearmonth={$(=Date(AddMonths(Max(Date#(Yearmonth,'YYYY MM')),-2),'YYYY MM')),$(=Date(AddMonths(Max(Date#(Yearmonth,'YYYY MM')),-1),'YYYY MM')),$(=Date(AddMonths(Max(Date#(Yearmonth,'YYYY MM')),-0),'YYYY MM'))},Yearnumber=,Monthnumber=,Quarter_code=,Bookyear_code=,Bookyear=,Monthname=,Quarter=,Quater_name=>} Satisfaction_Score)/Sum({$<Yearmonth={$(=Date(AddMonths(Max(Date#(Yearmonth,'YYYY MM')),-2),'YYYY MM')),$(=Date(AddMonths(Max(Date#(Yearmonth,'YYYY MM')),-1),'YYYY MM')),$(=Date(AddMonths(Max(Date#(Yearmonth,'YYYY MM')),-0),'YYYY MM'))},Yearnumber=,Monthnumber=,Quarter_code=,Bookyear_code=,Yearmonth=,Bookyear=,Monthname=,Quarter=,Quater_name=>} pond),'Obs < 100')
Finally found. For some reason set analysis has a problem with the space in the field YearMonth (YYYY MM).
Just used another value and that seems to work fine..