MnR Posted January 30, 2005 Share Posted January 30, 2005 Hi, I have asked a lot about the count function, but now i have solved my structure problem i still have a similar problem. I need a calculation which can count the ID's in my order table but exclude the ones that have a field "Cancel" set to Yes. This needs to return a total, i tried using a summary field but that wouldn't let conditions be used, unless i missed them MnR Link to comment Share on other sites More sharing options...
transpower Posted January 30, 2005 Share Posted January 30, 2005 Have you tried using PatternCount? Link to comment Share on other sites More sharing options...
Vaughan Posted January 31, 2005 Share Posted January 31, 2005 Make a calculated field, let's call it ActiveIDs... If( Cancel = "Yes" ; "" ; ID ) Use this calc field for your summary field. Link to comment Share on other sites More sharing options...
Søren Dyhr Posted January 31, 2005 Share Posted January 31, 2005 You might also put a button ontop of the checkbox in each line of the spoken-for's in the template we debated in: http://www.fmforums.com/threads/showflat...true#Post144404 ...Script filling yet another portal with the canceled via yet another mulitinekey, which makes them availible for say discounted price ...but not eliminated from the line in the assigned Turkeys. --sd Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6627 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