Create a calculated field similar to the following:
Then, place it on the view, right click and select, Compute Using...>EVV Quote
Hope this helps!
Hi Tracy - thanks for the suggestion, I am really close now. Please see the attached picture.
I am getting the correct count but I cannot get the view I need. I would like each customer name on a single line with a single number beside each name such as:
and so on. When I deselect the show header option for EVV quote number all of the quote numbers are eliminated from the view but I still have multiple rows of numbers. Any idea how I can get one row per customer with a single value for number of quotes?
Hello? Anyone? Could use some help here, thanks!