Distinct Count based on Input Field

[#1]

Hello all,

I have an issue that I can't seem to wrap my brain around.  I have a Table box with an input field "RankField" against another column "CriteriaField."  I need to find a way to get a distinct overall count of the items entered into the "Rank" input field, however when I do a Count(Distinct(RankField)) it gives me a count of the number of distinct entries in the "CriteriaField."

CriteriaField          RankField

Fast                         1    

Cheap                      2            

Light                        1

Durable                    3    

Small                       4

My count(distinct(RankField) total shows up as 5, not 4 as I would expect.  I have tried playing with the aggr() function but I cannot seem to get what I need.  Help please!!!

-Easton      

[#2]

may you share application with sample data?

regards

DArek

[#3]

Unfortunately, do to specific network limitations, I cannot export the application, though I can manually type specific segments of the script to assist.