3 Replies Latest reply: Oct 1, 2015 2:24 AM by jagan mohan rao appala RSS

    Top 20 fields in backend script

    P M

      Hi All,

       

      I want create one field in back end anyone can give some ideas for the same .

       

      =aggr(if( rank(((SUM({$<FiscalYear={$(=max(FiscalYear))}>}[Gross Sales ])

         -   SUM({$<FiscalYear={$(=max(FiscalYear))}>}[Sales Return ])

          -  fabs(SUM({$<[Is SRN]={0},  [GL Code]={"4000001"},

          FiscalYear={$(=max(FiscalYear))}>} [Credit Note ]))

           +  SUM({$<[GL Code]={"4000001"},

            FiscalYear={$(=max(FiscalYear))}>} [Debit Note ]))    /100000),4)<=12,Divi ), Divi )

       

      Thanks in Advance