Cumulative sum for current financial year to till-date & for previous yr.

[Former Member]

Hi,

Could anyone please suggest the procedure to be followed in reporting, to calculate the cumulative sum of 2 fields for different projects

1. Current financial year (from 01.04.2011 to today) and

2. Previous financial year (from 01.04.2010 to 31.03.2011)

Report output should be like this :

Projects names in ROWS

2 fields data for entire Previous fiscal year & Current fiscal year to till date in COLUMNS

Thanks,

AVN Rao

[former_member182470]

Hi,

You have to create variable on date characterstic should be processed by customer exit for your two KFs.

KF1 Logic: Lower limit=01.04.2011

Higher limit=current date

KF2 Logic: Lower limit=01.04.2010

Higher Limit=31.03.2011

Hope this helps.....

Regards,

Suman

[Former Member]

Hi,

i guess you want your report in this manner :-

Project Name PY KF CY KF

For this you can create 2 structures.

The structure in the rows will have your project name and the one in the Columns will haev to 2 KF's.

Create 2 restricted KF, where the restriction will be based on the Fiscal year Period and restrict it using the dates you want..

Incase, you want the PY values to be based on some user entered date, then you will have to create exit variables for the same.

I hope this helps.

Reg,

Rahul