Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ???
Hi
Try with this
Round(Sum({<PeriodID = {$(=Max(PeriodID)-1)},Year = ,Quarter = ,Month = ,Period = >} [Sales]))
Otherwise, can u post a sample file?
Hi,
Can you please remove the "$" sign infront of the set analysis and try. hope it will helps.
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 .
HI
Try like this
Sum({<Year = ,Quarter = ,Month = ,Period =, PeriodID = {$(=Max({<Year = ,Quarter = ,Month = ,Period =>}PeriodID)-13)}>} [Sales])