2 Replies Latest reply: Jul 3, 2012 5:39 AM by Eamonn Hannon RSS

    My % Performance Calculation is not accumulating correctly

      Hi everyone.


      I'm trying in vain to produce a calculation on Sales data as per the following details:


      The % performance calculation in the attached QlikView application is not accumulating the way I want it to.  The application shows sample data with Sales values, Target values, a Performance calculation (Sales - Target) and a % Performance calculation (Sales/Target). I have 'Full Accumulation' selected on the first 3 calculations and 'No Accumulation' on the % Performance Calculation. This produces a Daily % Performance value as expected.  However, what I want to do is produce an accumulated % value.  For example, for day 3 the % Performance should be 180/187=96.25%.  It is displaying as 80% (chart 1), which is the % Performance for day 3 with no accumulation.  If I switch on 'Full Accumulation' for the % Performance it displays as 294.35% (chart 2).


      Can someone advise me on what calculation I need to use to produce what I am looking for.


      Thanks & regards,