• mister white
  • NEWBIE
  • 0 Points
  • Member since 2011

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 0
    Replies

Hello. Sorry if this seems like a stupid question but it's been driving me crazy. I've tried different formulas and nothing seems to work. 

 

I have a report that shows created cases and its set in the Matrix format. I have the opened date on the left. When I choose a grouping type and choose day I get the date and not the day of the week. I also try to group by "Calendar Day in Month" but still can't get the graph to report the actually day of the month. 

 

Any help would be greatly appreciated. Thank you. 

 

 

Also, i get the following when trying to use the date formula. 

 

Error: Invalid custom summary formula definition: Formula result is data type (Text), incompatible with expected data type (Number).