Skip to main content
Newcomer
Mar 30, 2023 9:21 PM UTC

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.

1 reply

Employee - Sage
Mar 31, 2023 2:21 PM UTC

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