AnsweredAssumed Answered

Count records that fit two criteria?

Question asked by ezeitgeist on Dec 1, 2016
Latest reply on Dec 5, 2016 by BruceRobertson

There was a post a while back (2014) similar, but got no response so I am posting to see if there is a solution.


I want to count the number of records in a table that fit 2 specific criteria. Ie. Field A = "1" and Field B = "2".


In my research it looks like Get(FoundCount) might do it. I just need to have the count of a few different sets of records displayed in an admin dashboard. The description notes: "If you specify the context for the current calculation, this function will be evaluated based on that context; otherwise, it will be evaluated based on the context of the current window." Which I do not fully understand -- so can I make a script or calculation that names the table and does a search for the 2 criteria matching?


NB: Doing this on WebDirect, so if there are any WebDirect glitches related, I thought it would be good to note the delivery platform.