Skip to main content
C
CCI01
Newcomer
March 30, 2023

Calculating the difference between CY LTM versus PY LTM

  • March 30, 2023
  • 1 reply
  • 0 views

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

J
OneStream Employee
JackLacavaOneStream Employee
OneStream Employee
March 31, 2023

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

Terms & ConditionsAccessibility statement