10-11-2022 03:06 PM - last edited on 05-03-2023 09:30 AM by JackLacava
I currently have accounts tagged with a text value within Text1 default. There are rules which refer to the text value.
My question is, if beginning in 2022M6 (for example), how can I set this text value to blank to make sure the formula no longer runs on this account.
Let me know if there are any thoughts outside of entering spaces or a different value.
Thanks for the help.
Cheers!
10-12-2022 10:24 AM - edited 10-13-2022 04:40 AM
I assume you currently have a value assigned to Default Time. The procedure should be:
This should ensure that all past periods get a derived value that is the old text, and all periods from 2022M6 forward get a blank derived value.
10-12-2022 01:05 PM
Text Value can vary by Scenario & Time. With that said you can define value for each time period and your function should read the correct values.