3 Replies Latest reply on Apr 2, 2014 10:19 AM by IwaoAVE!

    Calculation to get distinct count

    dinoapolito

      Title

      Calculation to get distinct count

      Post

           Hi, 

           I have created a calculation field to get a distinct count of the number of occurences of order dates in a given table. I am using the execute sql function like this

           ExecuteSQL ( "select count(distinct(orderdate))"  ; "" ; "" ; ""  )

           I don't get any errors when the field is created but when I use it on a layout the result is ?

            

           I then tried putting in the from table

           ExecuteSQL ( "select count(distinct(orderdate) from orders)"  ; "" ; "" ; ""  )

           Same result.

           I'm doing something wrong and losing hair and sleep because of it

            

           Thanks

           Dino