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

xtensibilitybro's avatar
xtensibilitybro
New Contributor III
3 years ago

Set Text Value to Blank

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!

Methodology

2 Replies

  • JackLacava's avatar
    JackLacava
    Icon for OneStream Employee rankOneStream Employee
    3 years ago

    I assume you currently have a value assigned to Default Time. The procedure should be:

    1. Assign that value to the first period of the first year, creating a Stored Item. You do that by selecting the first period on the tree in the left-side of the pop-up that appears when you double-click on the Text property and entering a value.
    2. Assign a new value, which can be anything, to 2022M6, in order to create another Stored Item.
    3. Edit that second Stored Item and delete the placeholder value. DO NOT use the "Remove Stored Item" button.

    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.

  • Krishna's avatar
    Krishna
    Valued Contributor
    3 years ago

    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.