Hopefully this is a quick and easy fix. I've been playing around trying to get a trigger set up for my application to automatically set the fiscal year range based on another selection. However, I'm running into problems where the user cannot manually adjust the fiscal year unless they deselect their current selection.
I understand for having multiple 'Select in Field' values, you use the form ( X | Y | Z ), however, how should this be adjusted when introducing a number range?
The trigger is currently set up with the Search String value as ='<=$(vFiscalYearFilter)', which will automatically set up the fiscal year to include all years up until the year selected by the user in another dimension. However, one year is listed as TBD, which means I need to handle it as an exception. I've tried using multiple iterations of the following type of arrangement:
(='<=$(vFiscalYearFilter)' | TBD) - (<=$(vFiscalYearFilter) | TBD) - ('<=$(vFiscalYearFilter)' | 'TBD')
I'm sure I've tried more than that but you get the idea, it doesn't seem to be working. To solve my current problem, I'd like to be able to include the TBD as a standard selection (without going into the data and alter it to a year) or integrate a way for the user to be able to select it when the trigger is automatically adjusting everything. (I believe the former would be easier as the trigger does not allow the user to make any alterations to the fiscal year once a year has been selected). Thanks for any help you can offer!