Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

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

Recommended Posts

Posted

I would like to see if I could create a field that will give me a running count of record used in a cretin field.

Example: I have a value list with "boy", "cat", "dog" in it. I would like this NEW field to contain a running total of all the records that are using "boy", totaling with a Number. So if "boy" were used in 6 of my records this field would contain the number 6.

Can this be done?

Thanks,

RET

Posted

Here's one possibility:

Create three Calc fields -

Case(Value="boy", 1, 0)

Case(Value="cat", 1, 0)

Case(Value="dog", 1, 0)

then create three Summary fields that get the total of each of the three Calc fields.

Later :-)

This topic is 8729 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.