03-30-2023 05:21 PM - last edited on 05-24-2023 01:02 PM by JackLacava
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.
03-31-2023 10:21 AM
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).