2 Replies Latest reply: Nov 6, 2014 2:24 AM by ashok Velisetty RSS

    Want caculate Growth% in backend not in front end?

    ashok Velisetty


      Hi All,

       

      I want to calculate growth% in backend only, how can write expreession at backend.

       

      Formulae:

      Growth%=((Max year Qty-Prev year Qty)/Prev year qty)*100.

       

      Input:

      LocationYearQty
      A201210
      A201350
      A201420
      B201220
      B201360
      B201480
      C2012100
      C201340
      C2014200

       

       

      Output:

      LocationGrowth%-2013Growth%-2014
      A
      B
      C

       

       

      Note;

      Don't want to caculate at froent end need at backend only.