AnsweredAssumed Answered

Calculation to get distinct count

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

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

      

      

      

      

Outcomes