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

    Calculation to get distinct count



      Calculation to get distinct count



           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