Year to Date Calculation

[kuberacupidagra]

Hello All,

I have a field named Production Time(PRTM) which is updated in the table once a month. I have to report the accumulated PRTM for the year, basically, YTD_PRTM.

I am extracting todaymonth from current month and totalling for the year.

todaymonth = month(currentdate)

For todaymonth := 1 to 12 Do
(
YTD_PRTM = YTD_PRTM + tablename.PRTM
) exit for


I am new to Crytal Reports. Please let me know what is the problem. I am getting an error "The remaining text does not appear to be part of the formula".

Thanks,

Anil

 

[dgillz]

What is the purpose of your formula? Loops in crystal do not sum the database, they loop for that one record. I have never used a loop in crystal to total database values.

Instead write a simple formula:

If {YourDateField} in YearToDate then {YourFieldToBeSummed} else 0

Place this formula in the details section, right click on it, and select insert, grand total. If you do not want to see the details, hide the details section.



Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[kuberacupidagra]

Hello Instructor,

I tried your example and it gives an error "YTD_PRTM is an unknown field".

The field T_PRTM is the one to be summed to add up to YTD_PRTM. Below is the code which I used.


if {YTD_PRTM} in YearToDate then {MyDatabase.T_PRTM} else 0

I don't have YTD_PRTM field in the database and am using it just for diplaying.

Will look forward to hearing from you.

Thanks,

Anil

 

[kskid]

On the record containing {MyDatabase.T_PRTM}, is there a date field that identifies when the record was posted or created? That is the date field that dgillz is referring to.

In your rercord selection, all you have to do is select those records that fall within YearToDate. Then all you have to do is summarize {MyDatabase.T_PRTM}

A sample of your data record and expected output would be helpful.

-lw

 

[kuberacupidagra]

THANKS so much dgillz and kskid.

Yes, I used the a field T_CMDT(completion date).

if {TTICST002530.T_CMDT} in YearToDate then {TTISFC010530.T_PRTM} else 0

The YeartoDate function now compiles without errors.

Thanks and Regards,

AA

 

[kuberacupidagra]

The YearToDate function works fine as of now for one month of data. However, I have one question as I am still to check YearToDate output for the second and consecutive months. I have used the following formula:

if {TTICST002530.T_CMDT} in YearToDate then {TTISFC010530.T_PRTM} else 0

For 10/2005 (The first month of data) the YearToDate value for T_PRTM is(120) the same as that of 10/2005. In 11/2005 when I get new values for T_PRTM (say 125), the YearToDate for T_PRTM should add up to 245.

I am curious to know how Crystal Reports adds up the data for the next month as there is no field in the database called YTD_T_PRTM where it will store the YTD values.

Thanks,

AA