Anyone have a method to use distinct in a saved se...
# generalb
Brendan Altman
04/30/2024, 8:39 PMAnyone have a method to use distinct in a saved search formula?
🙌 1
m
MGBC
04/30/2024, 8:40 PMYes I’ve used distinct in a saved search. What are you trying to do
b
Brendan Altman
04/30/2024, 8:41 PMTrying to get the distinct number of amounts. So basically counting distinct
Brendan Altman
04/30/2024, 8:42 PMIm trying to compare the distinct number of amounts we have compared to a count of invoices
m
MGBC
04/30/2024, 11:05 PMdid you try a summary search but use a formula numeric Summary Type = Count Formula is DISTINCT({amount})
674 Views