AnsweredAssumed Answered

Sum of day of week

Question asked by KenDeFilipps on Oct 15, 2015
Latest reply on Oct 16, 2015 by user19752

If I have a field called DayOfWeek which is a text field containing various days of the week, how can I get a sum total or count of each day of the week.  I did create 7 new fields called sum_Sunday, sum_monday, etc. and tried various calculations, but having no luck. I have  a feeling I'm over thinking this and making it harder than it has to be.  Any suggestions would be greatly appreciated.

Thanks.

Outcomes