Calculating the difference between CY LTM versus PY LTM

CCI01
New Contributor

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.

1 REPLY 1

JackLacava
Community Manager
Community Manager

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