09-06-2023 04:53 AM
Hello everyone!
I’m trying to set up an Excel spreadsheet to be used in a dashboard, for users to be able to insert their FX rates in the Workflow.
I’m using the XFSetFxRate formula, and it works when I hard code the time, for example ‘2020M1’. However, I need the time to be dynamic, to change based on the workflow.
Is there a way to bring the Workflow time in the XFSetFxRate formula? I tried WF and WFTime, but it doesn’t work.
Thanks!
09-06-2023 07:02 AM
Hi @AndraEcxarcu !
I do not know how to do that using the WF Time easily. A simple workaround could be us a native excel dropdown list and point to the result of this drop down list in the XFSetFxRate Formula. That would make it dynamic and you could even add a formula that checks if the time selected is the current month.
Thanks,
Nic
09-06-2023 08:12 AM
Hi @NicolasArgente !
Thank you for the reply.
Yes, this is one solution, initially I didn't want the user to have to select anything in terms of time 😞 But if there is no other workaround, I guess I'll have to do it this way.
Thanks!
07-22-2024 07:42 AM
Assign the Text1 Property of the Spreadsheet component WFTime to |WFTime| and save the file in the 'example.xfdoc.xlsx' format, which is utilized for extensibility documents. In the Excel spreadsheet, enter the time as |WFTime| in any desired cell. When this spreadsheet is accessed in the OneStream application, it will display the Workflow Time.
Thanks,
Surya