current date 3

[mdelgado100]

I need a daily average.

Please help me find a formula or function where the current date of month (1,2,3,4....31) is used to average my occurances. That is where the reports recognized todays date and uses it in the average formula.

I am using crystal 8.5. with an Access Data base.

 

[vidru]

This formula will give you the Day of the current date:

Day(CurrentDate)

-dave

 

[pbateman]

day(today);

 

[ShortyA]

You could group on the date and set it to create a new group each day in the Group Expert. Then create either a formula to do the averaging eg:

Average({Table.Field},MyGroupName)

or you could just do an "Insert Summary" and use the Average Option within the group.