3 Replies Latest reply: Aug 22, 2012 5:25 AM by Stefan Wühl RSS

    Calculate Data by aggregation

    Jagan Vijayakumar

      Dear All,

       

      I have a data policyno, claimno, prem, claimamt.

       

      I want create a chart with policyno wise claimamt. claimamt should be caluculated by claimno and then sum to policyno wise base on the logic given.

       

      Post:
      ****
      If ClaimAmt of each claim is greater than 100000 then 100000 else ClaimAmt.

       

      Pre:
      ***
      If ClaimsAmt of each claim is greater that 100000 then ClaimAmt - 100000 else zero.

       

      Please let me know how to calculate Post & Pre column.

       

      The output should be like Output table. Only policy dimension to be used.

       

      Please see the qvw file attached for your reference.

       

      Thanks,

      Jagan. V