3 Month Calculation

[hkg_qlik]

Hi,

I have a straight table with 3 items:

1. LOT 1 - Lots per Month - Year

2. Defect - Defects per Month - Year

3. 3 Month Lot - I want the calculation for 3 Month Lot =

[ SUM(LOTS for 3 month) - COUNT (Defects for 3 month) ] / SUM(LOTS for 3 month)

For eg: If you look at the attached file the calculation for the 3 MONTH LOT under Mar 2012 :

(18 + 24 + 14) - (2+1+0) / (18 + 24 + 14) = 0.94

Regards,

H

[jagan]

Hi,

Can you attach some sample data? 

or Try this expressions

=(Sum({<DateDimensionName={'>=$(=MonthStart(Max(DateDimensionName), -2))<=$(=MonthEnd(Max(DateDimensionName)))'}>} LOTS) + Count({<DateDimensionName={'>=$(=MonthStart(Max(DateDimensionName), -2))<=$(=MonthEnd(Max(DateDimensionName)))'}>} DEFECTS) ) / Sum({<DateDimensionName={'>=$(=MonthStart(Max(DateDimensionName), -2))<=$(=MonthEnd(Max(DateDimensionName)))'}>} LOTS)

Hope this helps you.

Regards,

Jagan.