Counting ID's but with conditions

[MnR]

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

[transpower]

Have you tried using PatternCount?

[Vaughan]

Make a calculated field, let's call it ActiveIDs...

If( Cancel = "Yes" ; "" ; ID )

Use this calc field for your summary field.

[Søren Dyhr]

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