Requesting assistance with a formula needed in a cubeview row. Im looking to add a formula to my CF forecast column, so the formula in the row would be:
((A#AccountsReceivable:T#2024M12:S#Actual:V#MTD - A#AccountsReceivable:T#2025M1:S#Actual:V#MTD)) + ((A#AccountsReceivable:T#2025M1:S#Actual:V#MTD - A#AccountsReceivable:T#2025M2:S#Actual:V#MTD)) + ((A#AccountsReceivable:T#2024M2:S#Actual:V#MTD - A#AccountsReceivable:T#2025M3:S#Forecast:V#MTD))
Hi, this request is quite unspecific and it will be difficult for the community to get you to what you want to achieve. There are various ways to achieve this, and maybe dynamic or stored calculations may be an option too, depending on the exact requirements.
If you search for phrases such as "cube view formulas" or "cube view math" in this forum, you will find some posts.
In the documentation (OneStream Documentation - Release 8.4), you can search for input using the same phrases which will surface e.g. this section:
Create Cube View Column and Row Calculations
I hope this helps.
Hi,
To add to Henning's post, I would assume that you want the time periods to be dynamic rather than hard-coded to 2024M12, 2025M1, etc?
The member filter builder available from the cube view screen also has some getdatacell examples.
You can also raise a ticket with support if you need some hands-on help with building this rule.
Thanks
Where can I find the "Member Filter Builder" from the cube view screen? Yes please dynamic would be great
The Member filter builder is accessed from the button highlighted below.
