I have four text fields. For each one of them that equals an assigned
value, I want to return a 1 that is added together to get a sum.

For example:
textfield1 textfield2 textfield3 textfield4 calculation
black white black black

By having the calculation field as below I want it to return a value of
3:
If(textfield1 = "black", 1, 0) + If(textfield2 = "black", 1, 0) +
If(textfield3 = "black", 1, 0) + If(textfield4 = "black", 1, 0)

For some reason this function only returns "0". It makes no difference
if I say the calculation result is text or a number.

I tried simplifying the calcuation to: If(textfield1 = "black", 1, 0)
Still I only get 0 returned, or nothing if textfield1 is blank.

What am I doing wrong?

Thanks,
Dan

Using Filemaker pro 5.5 for windows.

Are you sure your text fields are really text fields and not number
fields? That's my guess.

Another way of doing it -- won't help if the text fields are really
numbers, but it might be simpler if your desired calc is really as
simple as your example:

patterncount(textfield1 & textfield2 & textfield3 & textfield4, "black")




D. wrote:
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg (818) 883-2846
FM Pro Solutions Los Angeles, California

FileMaker 7 Certified Developer
Associate Member, FileMaker Solutions Alliance

Disregard these posts. The problem is the field is based on a value
list. I will repost with a new question that is more specific to my
needs. Sorry about the mess if you have read this far.

Disregard these posts. The problem is the field is based on a value
list. I will repost with a new question that is more specific to my
needs. Sorry about the mess if you have read this far.

Disregard these posts. The problem is the field is based on a value
list. I will repost with a new question that is more specific to my
needs. Sorry about the mess if you have read this far.