calculation Help

[Matrixxdg]

Hi All,

I have two DB fields that I trigger Yes or No in the field.

 

I can do a FIND with Couples = Yes and then use  Get(FoundCount) and it gives me the total of Couples Checked In

 

I can do a FIND with TotalPeopleCheckedIn= Yes and then use Get(FoundCount) and it gives me the total of People Checked In

 

I want to display both of these totals on the same page and I am not quite sure where to start.

 

I tried this:  If ( couple="Yes"; Get(FoundCount)) as a calulation in a field called couples, that did not work.

 

Any help would be greatly appreciated.

 

Thanks..MG

[GisMo]

Maybe you write a simple script to do the find request(s) together(using extend found set) in the same find and then use get(foundcount). Or do one find, get the count and save the result to a variable and then do another find and add the foundcount to the variable and put in the field you need.

 

Is this helpful?

[Matrixxdg]

Thanks GizMo let me give that a try.