Forum Discussion

heatherwine's avatar
heatherwine
New Contributor II
8 months ago

Book - Pass Input Parameter to Loop?

Is there a way to pass the Required Input Parameters for a book into a loop?  For example if the users picks 2024M3 for time I want to be able to produce a report for that period as well as a report for -3 months and -12 months.  I can get T#POV, T#PovPrior3, T#POVPrior12 to work but I would like to use the input time instead.  

  • db_pdx's avatar
    db_pdx
    Valued Contributor

    Hi heatherwine: you're on the right track! You should be able to swap the Loop Member Filter to:

    T#|!Param_T_Quarters!|, T#PeriodPrior3(|!Param_T_Quarters!|), T#PeriodPrior12(|!Param_T_Quarters!|)

    I cannot tell from your screenshots, but I assume your reports are either using a Time parameter equal to Loop1Variable or you are setting the appropriate Time parameter to Loop1Variable in your Change Parameter.

    edit: wording