Help with Set Analysis

[#1]

Hi,

I have the following expressions contained in variables, extracted just for help purposes.

This calculates a value for each month but I need this to calculate a value for 3 months prior, i.e. If I select 201110, it must give me the value 201107 using set analysis.

"Period" is the date (Year/Month) field we are using.

The variable for 3 months prior's date is v3MonthsAgo.

=sum(aggr(if((sum( 
(
(((  (
           if(F_TRNS_AMT <= TOBR_LOW_CASH_VALUE_LEVEL , TOBR_Low_CASH_Factor ,TOBR_Ideal_CASH_Factor )  *     F_CASH_TOBR_Units
     )
     +
     F_TOBR_Units)  * TOBR_Unit_Reward  )  *  IF ( Accuracy_Amount_pm >= AccF_Step1_FROM  AND   Accuracy_Amount_pm  < AccF_Step2_FROM        ,        AccF_Step1_FACTOR        ,IF ( Accuracy_Amount_pm >= AccF_Step2_FROM  AND   Accuracy_Amount_pm  < AccF_Step3_FROM        ,        AccF_Step2_FACTOR        ,IF ( Accuracy_Amount_pm >= AccF_Step3_FROM  AND   Accuracy_Amount_pm  < AccF_Step4_FROM        ,        AccF_Step3_FACTOR        ,IF ( Accuracy_Amount_pm >= AccF_Step4_FROM  AND   Accuracy_Amount_pm  < AccF_Step5_FROM        ,        AccF_Step4_FACTOR        ,
     AccF_Step5_FACTOR        )))))
-
( Accuracy_Amount * AccFactorRATE)

)  ) +(sum( -  AccFactorRATE * Accuracy_Amount ) ) )<0,0,(sum( 
(
(((  (
           if(F_TRNS_AMT <= TOBR_LOW_CASH_VALUE_LEVEL , TOBR_Low_CASH_Factor ,TOBR_Ideal_CASH_Factor )  *     F_CASH_TOBR_Units
     )
     +
     F_TOBR_Units)  * TOBR_Unit_Reward  )  *  IF ( Accuracy_Amount_pm >= AccF_Step1_FROM  AND   Accuracy_Amount_pm  < AccF_Step2_FROM        ,        AccF_Step1_FACTOR        ,IF ( Accuracy_Amount_pm >= AccF_Step2_FROM  AND   Accuracy_Amount_pm  < AccF_Step3_FROM        ,        AccF_Step2_FACTOR        ,IF ( Accuracy_Amount_pm >= AccF_Step3_FROM  AND   Accuracy_Amount_pm  < AccF_Step4_FROM        ,        AccF_Step3_FACTOR        ,IF ( Accuracy_Amount_pm >= AccF_Step4_FROM  AND   Accuracy_Amount_pm  < AccF_Step5_FROM        ,        AccF_Step4_FACTOR        ,
     AccF_Step5_FACTOR        )))))
-
( Accuracy_Amount * AccFactorRATE)

)  ) +(sum( -  AccFactorRATE * Accuracy_Amount ) ) )),EmpNumber_sPeriod))