Thank you FalkoSchulz. I very much appreciate your help with this. ... View more

Hi Markus,  I managed to understand how the filter was working by creating a calculated item with the same code and looking at what was being included and excluded. In the end, I managed to work out that the filter could be simplified to the follow. ( 'Rolling Stocktake Year'p = 'Rolling Stocktake Timetable'n ) OR ( 'Controlled Item Indicator'n = 'YES' ) Much simpler and more readily understood 😄 Thanks for your help. ... View more

Hi Hunter_SAS, I experimented with the filter and was able to confirm what I think you've suggested. In this case, the available values for the parameter 'Stocktake Rolling Year' are controlled by another parameter (Year) and calculated item (Rolling Stocktake Schedule).  I found that the "in" comparators were blank as only one of the three values the parameter could take were available at any given time, depending on the value of the 'Year' parameter. If I change the comparator to '=' then this issue goes away 😄 Thanks so much for your help. ... View more