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
New Contributor III

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.