Hi,
unfortunately I'm not able to create a snippet without running into errors. Could someone help?
There is a snippet "Period Growth (Relative)":
Iif((ParallelPeriod([Date Hierarchy Level], [Distance], [Date Hierarchy].CurrentMember), [Measure]), ([Date Hierarchy].CurrentMember, [Measure]) / (ParallelPeriod([Date Hierarchy Level], [Distance], [Date Hierarchy].CurrentMember), [Measure]), Null)
the result for quantity this year vs. last year is 93%, that's correct.
But what I need is this result: -7%
Does anybody know the correct formula?
Thank you
Bianca