Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
The below expression considered for growth calculation in the report
(sum(sale_amount)/Before(sum({<Yr>}sale_amount))-1)
And
(sum(sale_amount)/Before(sum({<Yr>}sale_amount))-1)*avg(1)
Where avg(1) returns 1
2. if we give in set expression as {<Yr=>} instead {<Yr>} both does the same ??? to not get filtered year selection
* My Intention behind this is to understand this expression clearly
-Hope someone can help me with this
Super