This content has been marked as final. Show 3 replies
I have the following columns of data:
I need to add the Service_Count for Customer_IDs with DISTINCT Customer_ID & Service_Date, IF the Location_Code is 23.
How can I write an expression for this?
I originally had
Sum( If( Location_Code = '23', Service_Count, ))
Obviously this is incorrect, but did not know how to add the DISTINCT clause.
Any help is greatly appreciated.