Hello iam trying to do a calculation that counts the number of times a word appears in related records
Iam using a calculation field
I want to count Tests::Test Type for the word DSP
Cant seem to figure it out
Set up a "flag" field in Tests such as:
PatternCount ( Test Type ; "DSP" ) > 0
Now you can use the Sum function defined in the parent table to count your related records or a Total of Summary field defined in Tests could be used to get the same value.
How would I go about counting two different fields
For instant Test Type = DSP and Status = Awaiting Result
Ah managed to figure it out by doing
PatternCount ( Test Type & Status ; "DSP" & "Awaiting Result")> 0
Thanks for you help yet again :)
That checks your two combined fields for the string: DSPAwaiting Result. That will work if the fields contain one instance of DSP at the end of Test Type and one instance of Awaiting Result at the beginning of Status.
I think you want something more like this:( PatternCount ( Test Type ; "DSP" )> 0 ) AND ( PatternCount ( Status ; "Awaiting Result")> 0 )
Retrieving data ...