Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analysis.. I oversee something, but what?

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

2 Replies
Not applicable
Author

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')

Not applicable
Author

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..