Last Year cumulative value

[sagaraperera]

Dear All,

I am get a last year current month vale use this expression sum( {$<TRAN_YEAR = {"$(=Only([TRAN_YEAR]-1))"}>} [Actual]) This expression is hundred percent ok. but this expression Shaw only month value. I want cumulative value of last year. Please  help me

Thanks

Sagara

[tamilarasu]

Could you post your your TRAN_YEAR value.?

[sagaraperera]

My Script

LOAD BCOD,

     MONTH,

     YEAR,

     MONM,

     //NOTES,

     //NOTE_DESC,

     //AC_GP,

    // DATE(Floor(MonthEnd(MakeDate(YEAR,MONTH)))) as TRAN_DATE,

     DATE(Floor(MonthStart(MakeDate(YEAR,MONTH)))) as TRAN_DATE,

    // DATE(MonthEnd(Date#([YEAR] &'-'& [MONTH],'YYYY-MM')),'DD MMM YYYY')AS [TRAN_DATE],

      MONTH2,

     CLA_CODE,

     GROSS_PREMIUM,

     SRCC_PREMIUM,

     REINSURANCE_FUND,

     FOREIGN_COMPANIES,

     CEEDED_PREMIUM,

     NRP,

     UPR_CHARGE,

     NEP,

     SRCC_TC_COMMISSION,

     FOREIGN_CO_COMMISSION,

     COMMISSION_INCOME,

     NET_REVENUE,

     GROSS_CLAIMS,

     CLAIMS_RES_FUND,

     EXGRATIA_CLIMS_RES_FUND,

     CLAIMS_PROCESSING_EXPENSES,

     LEGAL_FEES,

     RI_RECOVERIES_RI_FUND,

     RI_RECOVERIES_SRCC_TC,

     RI_RECOVERIES_FOREIGN,

     SALVAGE_RECOVERIES,

     NET_CLAIMS,

     COMMISSION_EXPENSES,

     PRODUCTION_BONUS,

     DAC_CHARGE,

     ACQUISITION_COST,

     GROSS_PROFIT,

     STAFF_EXPENSES,

     ADMIN_EXPENSES,

     SELLING_EXPENSES,

     FINANCIAL_EXPENSES,

     DEPRICIATION_EXPENSES,

     MANAGEMENT_EXPENSES,

     INV_INCOME_EXT,

     INV_INCOME_INT,

     OTHER_INCOME_EXT,

     OTHER_INCOME_INT,

     INV_OTHER_INCOME,

     NET_PROFIT

FROM

I USE CAL

Trandatecalender:

LOAD

DAY(TRAN_DATE) AS TRAN_DAY,

DATE(TRAN_DATE) AS TRAN_DATE,

DATE(monthstart(TRAN_DATE), 'MM-YYYY') as MONTH_YEAR,

WEEK(TRAN_DATE) AS TRAN_WEEK,

YEAR(TRAN_DATE) AS TRAN_YEAR,

MONTH(TRAN_DATE) AS TRAN_MONTH,

MONTH(TRAN_DATE) &'-'& WEEK(TRAN_DATE) AS MONTH_WEEK;

LOAD DATE (TRAN_MINDATE + ITERNO() -1) AS TRAN_DATE WHILE (TRAN_MINDATE + ITERNO () -1) <= NUM (TRAN_MAXDATE);

LOAD

MIN(TRAN_DATE) AS TRAN_MINDATE,

MAX(TRAN_DATE) AS TRAN_MAXDATE

RESIDENT PL;

[tamilarasu]

Try,

sum( {$<TRAN_YEAR = {"$(=Max(Year([TRAN_YEAR]))-1)"}>} [Actual])

[Chanty4u]

hi,

chk below thread

Set Analysis for certain Point in Time