Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I have to calculate growth for two brands X and Y and I have used the formula
=(Sum(Volume)/Below(Sum(Volume)) - 1)
but it is missing data for the last year in the graph.
Currently the selected years are 2022,2021 and 2020.
Below(Sum(Volume)) will return null for 2020, since 2019 is not selected, so the entire formula correctly evaluates to null and no value is returned.
I understood.
Is there any other way to calculate the growth/decline so that I can see the result for all the selected years?