Skip to main content
Newcomer
Sep 15, 2022 5:49 PM UTC
Solved

Dynamic Prior

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?

db_pdxAnswer
Contributor
Sep 15, 2022 6:18 PM UTC

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

 

2 replies

db_pdxAnswer
Contributor
Sep 15, 2022 6:18 PM UTC

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

 

DCarrilloAuthor
Newcomer
Sep 15, 2022 6:25 PM UTC

Hi, thank you! That worked!