cumulative

[sagaraperera]

I want to cumulative value it should be a related to month value eg feb 2015 value related to jan 15 + feb 15. i have a month field it was select to month of feb cumulative value should be Shawn on only jan and feb15

can i help me

sagara

[sunny_talwar]

You can use a combination of Aggregate, RangeSum and above functions to achieve what you are trying to do. This is the best I can help you with amount of information you have provided here.

Best,

Sunny

[sagaraperera]

When I need a month of compensation to the value of the current value of the previous several months plus CUMULATIVE get appreciated.

[sagaraperera]

When I need a month of compensation to the value of the current value of the previous several months plus CUMULATIVE get appreciated.

sagara

[sunny_talwar]

Would you be able to provide sample data or application to work with?

Best,

Sunny

[sagaraperera · Accepted solution]

BCOD,

     MONTH,

     YEAR,

     MONTH2,

     CLA_CODE,

     MONM,

     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

[..\..\qlickviwe\P&L\P&LBUDDATA2011_2014.QVD]

(qvd);