MnR Posted January 27, 2005 Share Posted January 27, 2005 hi, how would i use a count function to return the number of occupied records? The occupied records would have the WeightNeeded filled in and i need to count these, but exclude ones with a field called "Cancel?" set to Yes. or i have just thought, or even better would it be possiable to make a script which when field "WeightNeeded" is occupied takes 1 off a global field so then i can get how many i have left? Link to comment Share on other sites More sharing options...
-Queue- Posted January 27, 2005 Share Posted January 27, 2005 Create a calculation of not IsEmpty(WeightNeeded) and Cancel <> "yes". This will return 1 when both tests are true. Then Sum(relationship::calcfield) will produce the number of related records which contain 1 in the calc, depending on the relationship. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7028 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 accountSign in
Already have an account? Sign in here.
Sign In Now