Optimise Code

[Surya]

Dear All,

if(RecNo = 1 or PEEK(MATERIAL) = MATERIAL,0,
IF(FREQUENCY_DAYS_MAC = 1,SUM_PROD_QTY_DAILY_MAC,

IF(FREQUENCY_DAYS_MAC = ,SUM_PROD_QTY_DAILY_MAC + PEEK(SUM_PROD_QTY_DAILY_MAC),

IF(FREQUENCY_DAYS_MAC = 3,SUM_PROD_QTY_DAILY_MAC + PEEK(SUM_PROD_QTY_DAILY_MAC)+Peek(PEEK(SUM_PROD_QTY_DAILY_MAC)),

IF(FREQUENCY_DAYS_MAC = 4,SUM_PROD_QTY_DAILY_MAC + PEEK(SUM_PROD_QTY_DAILY_MAC) + Peek(PEEK(SUM_PROD_QTY_DAILY_MAC)) + PEEK(Peek(PEEK(SUM_PROD_QTY_DAILY_MAC))),

IF(FREQUENCY_DAYS_MAC = 5,SUM_PROD_QTY_DAILY_MAC + PEEK(SUM_PROD_QTY_DAILY_MAC) + Peek(PEEK(SUM_PROD_QTY_DAILY_MAC)) + PEEK(Peek(PEEK(SUM_PROD_QTY_DAILY_MAC))) + PEEK(PEEK(Peek(PEEK(SUM_PROD_QTY_DAILY_MAC))))

Like we need to implement 90 days..Please suggest easiest way to achieve this.

[Anil_Babu_Samineni]

I would go with Flags for number of arbitrary ranges on each section.

[Surya]

Please give some example..it will help to me.

[Anil_Babu_Samineni]

Please explain the business logic?