- OneStream Community
- Forums
- Reporting
- Variance Percent Calculation
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Variance Percent Calculation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-18-2023 03:03 PM
The formula I created to calculate the MoM Variance% does not work. I am using the column filter to do the calculation. MoM Variance and Prior Year are calculations based on other columns in the report. What am I missing?
GetDataCell(BWPercent(CVC(MOM_Variance), CVC(Prior_year))):Name(MoM Change %)
- Labels:
-
Cube View
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-19-2023 02:15 AM
Hi
Can you give us a little more information what exactly isn’t working?
Cheers
Christian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-22-2023 12:12 PM
I was able to figure it out, thank you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-11-2024 07:26 PM
Hello,
Can I know what you did? I'm having a similar issue.
Thanks!
Will
