AnsweredAssumed Answered

Calculation to get distinct count

Question asked by dinoapolito on Mar 30, 2014
Latest reply on Apr 2, 2014 by IwaoAVE!


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