4 Replies Latest reply on Feb 14, 2020 10:08 AM by Rohit Yeruva

    Trying To Get One Instance Of An Account

    Adrian Santana

      Using a database that is based off of order history. Trying to do a distinct count of accounts per year that has purchased. But because of the number of orders per year instead of it showing 1 it's showing me the account 7 times because it has 7 orders for the year. What calculation can I do to make it show 1 time?

       

      Thanks!