Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Distinct Transaction Date
Not sure if i am over complicating my saved search here, but this is what i am looking to do:
Show number of customers who had their first transaction by month grouped by lead source..
I am able to get the list but what i am having difficulties in is the count. Here is the formula i am using:
case when to_char({firstsaledate}, 'MM') = to_char({today}, 'MM') then 1 end
and then adding -1, -2 etc... to get previous months.
Now what i am finding is if a customer has more than one transaction in the same month of their first transaction, they are been counted more than once.
0