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

Sophie's avatar
Sophie
New Contributor
3 years ago

Custom Member Frequency filter for all previous periods

Hi All, We'd like to have a Form Template available only until 2022M9. To do so, we've entered the following parameters in the member Frequency filter of the Form Template: Is it possible to ...
Forms
Sweez's avatar
Sweez
Contributor
3 years ago

Let's try this Sophie.  If you use this rule what exactly does not work for you as you expect?  What do you expect as the result vs what do you get.

 

  • Sophie's avatar
    Sophie
    New Contributor
    3 years ago

    Hi Sweez, 

    I'm expecting to be able to use a formula in the frequency filter in Form Templates section, (Application  > Data collection > Form Templates) as below:

    Only the AllPriorInYear part of the formula works. The concerned cube view appears in the workflows from January to August 2022. But it does not appear in 2021. 

     

    However, I've tester the formula in a cube views here: 

    And It does show all the required periods in a table:

    I've tried both formulas in Frequency filter: XBFR and BRString. 

    None of it makes the Cube view appear prior to 2022.