AnsweredAssumed Answered

Count records

Question asked by RitteT on Jan 6, 2011
Latest reply on Jan 6, 2011 by philmodjunk

Title

Count records

Post

I want to add a field where it calculates the count of records based on a specific field.

Let's say that I have 1000 records.

And in 3 of the records, the value in one of the field is "Yellow" so I want a field that display 3 based on the count of records that match "yellow" in that specific field.

I also want to add one more criteria, the "created date".

I've looked at count-function, but the seems only to count within the record. (I always get value "1").

I did some reading and I suspect that I've to use relations. 

I'm not very good in using relations, so I may need some help here.

Thanks!

Last edit: Solved everything.

Outcomes