Forum Discussion

jshaffer's avatar
jshaffer
New Contributor
2 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

Sort By
  • ChristianW's avatar
    ChristianW
    Valued Contributor
    2 years ago

    Hi

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

    Cheers

    Christian

    • jshaffer's avatar
      jshaffer
      New Contributor
      2 years ago

      I was able to figure it out, thank you. 

  • WillVitale's avatar
    WillVitale
    Contributor
    2 years ago

    Hello,

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

    Thanks!

    Will