jamesd ⚪️

Is there a way to get the Summary Number to group on the date so that I can get these numbers to match?

Shouldn't using Count Distinct force it to only count each customer once, whether it's in the card or the summary number?

Yeah it stays at 1 whether I choose first or last value.

I thought it would be that simple that causes the summary value to change to just 1.00

Okay this worked, then you just have to write a beast mode to clean up your date format. Appreciate the help. Thanks!

Yes, I knew there were the restrictions as notated in the user privelages, however, I was hoping there were some customization options to the user's access. Thanks,