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
Solved
Cube View Variance Calculation Issue
One row in my cube view is calculating a strange variance and variance %. I am subtracting an account member from a parent account in my Row member filter builder. Dep, & Amort is included in my SG...
Hi Denis, I think you are trying to achieve something like my example below:
Compared to your settings, I have changed two things - I have two columns, one with CY and one with PY and I use CVC for the variance calculations (you can do the same using only one column but you need to use indexes).
More important, I am using row overrides on the two calculated column (otherwise the row formula takes over)
Please let me know if that works for you as well.
Noemi
OneStream Employee
OneStream EmployeeHi Denis, I think you are trying to achieve something like my example below:
Compared to your settings, I have changed two things - I have two columns, one with CY and one with PY and I use CVC for the variance calculations (you can do the same using only one column but you need to use indexes).
More important, I am using row overrides on the two calculated column (otherwise the row formula takes over)
Please let me know if that works for you as well.
Hi Naomi,
I am having the same issue. Would you mind posting your solution?
- Noemi
Hi Julia, your issue is similar in a way that you have formulas in both the rows and the columns? And you would like the column calculation to override the row calculation?
In this case, you can use a row override on your column like in my example:
Please let me know if that helps.
Thanks,
Noemi
Thank you. It worked!