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.


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


      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.



      Jagan. V