set Analysis help with blank value for the field {Month = >}

[#1]

Can someone help me to understand the below ,especially, the functionality of the blank value  as Year = , Quarter=

round(Sum({$<PeriodID = {$(=Max(PeriodID)-1)},Year = ,Quarter = ,Month = ,Period = >} [Sales]))

From the above, my understanding is Year, Quarter, Month, Period fields are disregard fields even if the user selects values from these fields it must be disregarded but if I select values from Year,Quarter or any of these fields in my doc the data is getting updated - its not disregarding ???

[MayilVahanan]

Hi

Try with this

Round(Sum({<PeriodID = {$(=Max(PeriodID)-1)},Year = ,Quarter = ,Month = ,Period = >} [Sales]))

Otherwise, can u post a sample file?

[#3]

Hi,

  Can you please remove the "$" sign infront of the set analysis and try. hope it will helps.

[#4]

Agreed, currently selection is the default selection , I no need to specify explicitly $.

Anyhow I removed $ now, but if I select month from the calendar it still accounted for. Kindly refer the attached qvw doc and throw some lights .

[MayilVahanan]

HI

Try like this

Sum({<Year = ,Quarter = ,Month = ,Period =, PeriodID = {$(=Max({<Year = ,Quarter = ,Month = ,Period =>}PeriodID)-13)}>} [Sales])