4 Replies Latest reply: Apr 2, 2014 4:49 AM by Mangal Kamble RSS

    Why sum is not working ?

      Hello,

       

      I have a function :

      if(RangeSum(Above(sum({$<[ZZZ] ={'NO'}>} (if ([SSS'13]+[PPP'13]-[SSS'06]-[PPP'06]> 0, [SSS'13]+[PPP'13], 0)))/sum(TOTAL <Subcategory> if ([SSS'13]+[PPP'13]-[SSS'06]-[PPP'06]> 0, [SSS'06]+[PPP'06], 0)), 0, RowNo()))<0.8,'A','B')

       

      which is working properly.

       

      However I don't know why I can't sum 'A' or sum 'B" ?

       

      e.g.

      sum( if(RangeSum(Above(sum({$<[ZZZ] ={'NO'}>} (if ([SSS'13]+[PPP'13]-[SSS'06]-[PPP'06]> 0, [SSS'13]+[PPP'13], 0)))/sum(TOTAL <Subcategory> if ([SSS'13]+[PPP'13]-[SSS'06]-[PPP'06]> 0, [SSS'06]+[PPP'06], 0)), 0, RowNo()))<0.8,'A','B') )

       

      Is it any limits to use sum in one expression ? ( like in excel 7 times 'if' )