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

jshaffer's avatar
jshaffer
New Contributor
3 years ago

Variance Percent Calculation

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 %)

 

 

 

 

Cube View

3 Replies

  • ChristianW's avatar
    ChristianW
    Icon for OneStream Employee rankOneStream Employee
    3 years ago

    Hi

    Can you give us a little more information what exactly isn’t working?

    Cheers

    Christian

    • jshaffer's avatar
      jshaffer
      New Contributor
      3 years ago

      I was able to figure it out, thank you. 

  • WillVitale's avatar
    WillVitale
    Contributor II
    2 years ago

    Hello,

    Can I know what you did? I'm having a similar issue.

    Thanks!

    Will