Jump to content

counting records


This topic is 2100 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi , the following is very simple just can't to the bottom of it

i have a field which has a value of a color.

i want to get the found count of the record but it should only count every color once meaning 

record 1 - red

record 2 - green

record 3 - blue

record 4 - green

 

my result should be 3

i would appreciate if someone could help me out on this.

Edited by H
Link to comment
Share on other sites

If you created a summary field (sListColor), 'list of' with your color field (YourTable::color field) you would get:

red

green

blue

green 

for your summary field based on your found set.

Then the expression, once again based on your found set of records:

valuecount(UniqueValues (YourTable::sListColor ))

would return 3.

You could also do this with a one row, one field self join portal, or if you wanted to skip all that, you could use a SQL statement (which I couldn't figure out, but probably easy for one of the developers).

Edited by Steve Martino
additional info
Link to comment
Share on other sites

This topic is 2100 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.