Forum Discussion

DCarrillo's avatar
DCarrillo
New Contributor III
3 years ago

Dynamic Prior

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?

Reports
  • db_pdx's avatar
    db_pdx
    3 years ago

    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

     

  • db_pdx's avatar
    db_pdx
    Valued Contributor
    3 years ago

    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