gremlin9297

ExecuteSQL Unique Count shows a "?"

Discussion created by gremlin9297 on Oct 6, 2016
Latest reply on Oct 7, 2016 by fmpdude

Hi everyone,

 

     Im trying to run a an an ExecuteSQL calculation that counts the unique SSN in a found set, this is the calculation im using:

 

ExecuteSQL ("SELECT COUNT ( DISTINCT SSN) FROM \"36 Contributions \" " ; "" ; "" )

 

SSN is the Field name

36 Contributions is the Table name

 

I'm placing the calculation in the Trailing Grand Summary, not sure why i'm not getting any results

 

Any help would be appreciated thank you!

Outcomes