Forum Discussion

CCI01's avatar
CCI01
New Contributor
3 years ago

Calculating the difference between CY LTM versus PY LTM

Hi,

 

I'm trying to setup a variance account under UD8 that will calculate the variance between the current year last 12 months and the prior year last 12 moths. Any suggestions on how to write this formula?

Thanks.

Cube View

1 Reply

Sort By
  • JackLacava's avatar
    JackLacava
    Community Manager
    3 years ago

    Maybe have a look at the Trailing12MonthTotal View member, that might do the heavy lifting for you? If that suits you, it's then just a matter of dropping it into the Variance function in GetDataCell, using Time functions to reference the previous year (check the Member Filter Builder, both in Time Functions and Samples tabs).