07-18-2023 09:09 AM
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&A parent and I want to report separately. However, my variance column and Var % calculation is off. It is the only row having this issue. Also, I am not able to get the currency presented in the row.
Any suggestions are appreciated.
Solved! Go to Solution.
07-19-2023 09:15 AM - edited 07-19-2023 11:35 AM
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.
07-18-2023 09:23 AM
Hi Jennings,
Can you check if your SG&A account is setup properly as it isn't showing currency also BW calculations consider account type during calculation.
Thanks, Omkareshwar
Archetype Consulting
07-18-2023 09:27 AM
I appreciate the quick reply. SG&A is setup as an expense.
07-18-2023 11:02 AM
You don't have double quotes around the GetDataCell and Name arguments, and that ampersand might be tripping things up. I'd try with quotes and without the &.
If not that, it's probably a POV issue.
07-18-2023 11:09 AM
Hi Jack, appreciate the response. Thank you.
I believe that I made the updates you suggested but I'm still getting the same issues.
07-19-2023 09:15 AM - edited 07-19-2023 11:35 AM
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.
11-16-2023 11:01 PM
Hi Naomi,
I am having the same issue. Would you mind posting your solution?
11-17-2023 04:04 AM
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
11-17-2023 10:19 AM
Thank you. It worked!
07-20-2023 01:38 PM - edited 07-20-2023 01:38 PM
Thanks Noemi, this worked.