Calculation help

[mcinfly]

I'm still learning the FM calculation syntax...it just hasn't clicked yet. I have a simple problem that needs a simple solution (to anyone but me).

I have a calculation field in one table that needs to return a total COUNT of records from another related table If the records in the other table are = "enter text here."

I've been messing around with a few different functions, but I can't get it right. Help is much appreciated!

[Raybaudi]

...needs to return a total COUNT of records from another related table If the records in the other table are = "enter text here."

If a determined field of the related record as that string inside, than you have to count that record

[color:red]OR

whatever field contains that string, than you have to count that record ???

[mcinfly]

That makes sense. However, writing the calculation is still stumping me. I keep getting errors in my script when I try to save it or it returns nothing at all which leads me to believe I'm going about it all wrong. Do you have a suggestion?

[Raybaudi]

Hi mcinfly

my post was a question !

Row 1 or Row 2 ?

[mcinfly]

Row 1

[Raybaudi]

So two fields in the related file:

Trigger - calc field and calc:

Case(

yourTextField = "enter text here" ;1;0

)

Count - summary field (count of trigger)

[mcinfly]

That worked like a charm! I was so close to it on my own too. Oh well, one more thing for me to store in my mental FM library. Thanks for all your help!