problems with a count formula......

[Goha]

I am trying to create a formula that that does the following

Before:
------
john doe 1/1/2000 5
1/1/2000 5
1/11/2000 5
1/11/2000 5
1/12/2000 5

After:
------
john doe 1/1/2000 2
1/11/2000 2
1/12/2000 1


I am having trouble with this count part this is the formula I have so far

Count ({Voucher.voucher_no}, {@name} )

I think I need to use the three param field one but I keep getting errors, this is what I have...

Count ({@name} , {Voucher.pu_date_time}, "daily&quot

it says a summary field cannot be created

 

[synapsevampire]

It might be easier to just create a group in the report by name and date.

Then just right click on the voucher field within the details and select insert->Summary->count and select the date field to group by.

Now suppress the detail line and pace whatever fields you need in the date footer.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[Goha]

thanks

 

[rvoller]

Yep, insert a group, select date as the group, put name and date in the group header or footer (it doesn't matter).
That's it.