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
XFGETCELL stuck in #REFRESH when referring to a TIME dimension that is a formula
When I use a formula to set-up the time member, the XFGETCELL formula that refers to this time member is stuck in #REFRESH. The weird thing is, if I go in the XFGETCELL formula and hit enter without ...
could this setting in the following KB be causing this issue?
https://onestreamsoftware.service-now.com/sp/?sys_kb_id=53d8d0761bb57050bc19da4cbc4bcb79&id=kb_article_view&sysparm_rank=5&sysparm_tsqueryId=b7f4bcdf1b40c910d238b8c2cc4bcbc2
We've tried playing around with that setting, when it is false and we open the file, the values are there, but the moment we click refresh, the value changes to #REFRESH and there does not seem to be a way to get it back except to go into the formula and hit enter. If the value is TRUE, it starts off as #REFRESH and does not change even after we click refresh, so it does not seem to be related to our issue.