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!