Sum One Check Amount with multiple rows of the same data by using DISTINCT ?
I am looking to ONE "CHECK AMOUNT" per distinct "first name" AND "check date".
the data source has multiple lines for the same check amount, but i only want to count one "check amount" per "first name" and "Check date"
this data is in DOMO but i just downloaded it to understand the layout of the data better.
Any Ideas ?