How i get the first 6 months

[slondono]

Hi guys.

Need a hand here. I need to calculate the payments but only the first six months.

the problem is that I do not have the month as a dimension, I have the date in format YYYYMMDD.

I dont know how to elaborate a set analysis that give just the first semester (six first months)

Can anyone help me?

[sunny_talwar]

What do you mean by 1st 6 months? You mean the latest 6 months?

[maxgro]

=sum( {$<[Date YYYYMMDD]={">=$(=date(makedate(max(YEAR)),'YYYYMMDD'))

<=$(=date(MonthEnd(makedate(max(YEAR),6)),'YYYYMMDD'))"}>} yourfield )