Skip to main content
D
DCarrillo
Newcomer
September 15, 2022
Solved

Dynamic Prior

  • September 15, 2022
  • 1 reply
  • 0 views

DGC_0-1663262366454.png

T#PeriodPrior1(|!DRU_Year!|):Name(April 30, 2021)

 

The member filter above is not dynamic since I am hard-coding 2021 in the second column. How can I make the second column be a prior period based on the first column?

Best answer by db_pdx

Hi DGC: does the T#PeriodPrior1(|!DRU_Year!|) resolve to a full year time period?  If so, you can use :Name(April 30, |MFTime|)

Cheers     -DB

 

1 reply

D
db_pdxAnswer
Contributor
September 15, 2022

Hi DGC: does the T#PeriodPrior1(|!DRU_Year!|) resolve to a full year time period?  If so, you can use :Name(April 30, |MFTime|)

Cheers     -DB

 

D
DCarrilloAuthor
Newcomer
September 15, 2022

Hi, thank you! That worked!

Terms & ConditionsAccessibility statement