Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I do not know why I do not get data for previous period, although data exist in both periods, if I select one period. But if I unselect the selected period I see data for booth periods.
Here are expressions set:
Previous Period: avg({$<FPeriodID={$(=max(FPeriodID)-1)}>} Amount)
Selected Period: avg({$<FPeriodID={$(=max(FPeriodID))}>} Amount)
It is something obvious but I can't see it today.
Thanks
Hi
Most likely the field FPeriodID is connected to another field, or you are making selections on another field that is affecting your results. You need to override these related fields, like
avg({<FPeriod={...}, Period=, FYear=>} ....
HTH
Jonathan
What happens when you change the set to all values?
Previous Period: avg({1<FPeriodID={$(=max(FPeriodID)-1)}>} Amount)
Selected Period: avg({1<FPeriodID={$(=max(FPeriodID))}>} Amount)
Hi
Most likely the field FPeriodID is connected to another field, or you are making selections on another field that is affecting your results. You need to override these related fields, like
avg({<FPeriod={...}, Period=, FYear=>} ....
HTH
Jonathan
Exactly. I was using FPeriod (P08, P09, ...) for selections and FPeriodID (56, 57, ...) in the set analysis to show properly previous period when P01 is selected.
Thank you very much Jonathan. Cheers