Tagged: Count, Instance Number, random, total
This topic contains 4 replies, has 0 voices, and was last updated by Anonymous 8 years, 1 month ago.
- AuthorPosts
- May 6, 2011 at 1:30 pm #760
AnonymousIs there a way to get the total number of instances for my reporting?
I’m trying to generate a Random winner for a contest using the Random function and I want to set the Maximum value to be the number of instances… I could just go look at the last Instance Number but I’ve come across this a few times during form building so I was wondering if there was a way that I could pull it dynamically instead.
Thanks!
May 6, 2011 at 3:59 pm #5723If you are building a report you can use a Value reporting object. Set the value drop-down to “count” and set the field to a field that is filled out on every instance. That will give you a count of instances.
May 6, 2011 at 4:03 pm #5724
AnonymousI hadn’t even thought of that – That’s perfect, thank you!
January 8, 2013 at 4:34 pm #6364Hi, Dennis, is it possible for the Value reporting object to get a count of certain value appear in one of the fiels based on my specification? How should I do that? Thank you.
I tried with formula (when a field = certain value) for the Value object, but maybe I did not do it correctly so it is not working and continues to show the total instances count.
January 8, 2013 at 10:26 pm #6367Sorry, I don’t understand the question. I can tell you however, that it is not possible to use the values in reporting objects in formulas or functions.
- AuthorPosts
You must be logged in to reply to this topic.