1 Reply Latest reply: Mar 27, 2017 10:17 PM by Sunny Talwar RSS

    Aggr Function issue

    Peter Wischi

      Hi All

       

       

      I have an sql data set which has a myriad of columns, however what I am trying to  do is create an aggr expression whereby the GrossAmount returned is based upon the BkClaimNo, ClaimPaymentRecoveryType ='Payment' and IsCurrentTransaction='-1'

      The exspression I am using is below.

       

      I have attached a very small subset of the data for visual reference and would in the first instance like to know whether my expression is logical. Obviously I am not getting the correct answer and need to determine whether my expression is valid or not which will then determine the next step

      sum(aggr(sum(GrossAmount),BKClaimNo,ClaimPaymentRecoveryType='Payment',IsCurrentTransaction='-1'))

       

      Cheers in advance