How to calculate Growth%

[sakshikaul]

Hi

I want to calculate the growth% but this is giving me a wrong result

To calculate  growth% formula should be

Current year- Previous year/Previous Year

I am applying same formula here its not giving correct results.............

= num((sum({StateB < Sold_Date = {">=$(sstart)<=$(eend)"} >}quantity_sold )-(sum({StateB < Sold_Date = {">=$(sstart)<=$(eend)"} >}quantity_returns )

-

(sum({ stateA< Sold_Date = {">=$(From)<=$(To)"} >}quantity_sold )-(sum({stateA < Sold_Date = {">=$(From)<=$(To)"} >}quantity_returns )

/

Sum({stateA< Sold_Date = {">=$(From)<=$(To)"} >}  quantity_sold)-(sum({ stateA< Sold_Date = {">=$(From)<=$(To)"} >}quantity_returns )))))), '#,##0.0')

[m_woolf]

Your formula is missing parentheses:

(Current year- Previous year)/Previous Year

[balabhaskarqlik]

Try this:

= num((sum({StateB < Sold_Date = {">=$(sstart)<=$(eend)"} >}quantity_sold )

   -

       sum({StateB < Sold_Date = {">=$(sstart)<=$(eend)"} >}quantity_returns )

   -

       sum({stateA < Sold_Date = {">=$(From)<=$(To)"} >}quantity_sold )

   -

       sum({stateA < Sold_Date = {">=$(From)<=$(To)"} >}quantity_returns ))

/

       (Sum({stateA < Sold_Date = {">=$(From)<=$(To)"} >}quantity_sold)

   -

        sum({stateA < Sold_Date = {">=$(From)<=$(To)"} >}quantity_returns )), '#,##0.0')