Crystal Reports - Adding a sum of a field per day
I am trying to get solution for the sum of per day but i am not able calculate per day, per month is working when i am adding the number, please help me how to fix this issue



(SELECT (Sum("ShoretelPhone"."NACD_EXternal_OUT"))
from "ShoretelPhone"
where "ShoretelPhone"."a_number" = 4888 and month("ShoretelPhone"."a_date") = 5)