Basic Calc field

[ngwaltne]

I need to add up symbols in certain fields. For example how many ∆ (triangle if you do not see it) are there in ling_3 in a given found set. Would that be done as a script or field definition? Could someone help me get started.

Thanks in advance

Norm

[Pupiweb]

The calc is basically:

PatternCount (YourField,TheCharacter)>0

It will return 1 if there is at least one such character in a field

If you want to make it dynamic use a global field in which you enter the character you're looking for:

PatternCount (YourField,GlobalField)>0

To have a total on the found set create a summary field totalling the upmentioned field(s) ... in both cases but expecially in the second case (using a global field) the summary field might take quite a bit to recalculate