Do not see a previous period if the next period is selected

[nenadvukovic]

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

[#2]

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)

[jonathandienst · Accepted solution]

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

[nenadvukovic]

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