The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

DCarrillo's avatar
DCarrillo
New Contributor III
3 years ago
Solved

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

     

2 Replies

  • 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