so, here's what i've got. i need to count any field that contains the number 50 in it. for example, in this column of fields, i would have:

50

100

150

200

250

the result should be 3 in this example. what is the best way of doing this? i have tried to create a calculation field like this:

If ( Recommended Load Bill Count = "*50" ; 1 ; 0 )

then had a summary field count them up for the report...but that's not working. so, how do i get it to find any field CONTAINING 50, not necessarily equal to fifty.

You cannot use wild cards in a calculation. Try =

PatternCount ( Recommended Load Bill Count ; "50" ) > 0

then SUM this field.

Not sure what the purpose is here, though. Should "500" also be counted?

that worked perfectly! thank you! i'm going to have to look into that function a bit more.

that's what i love about fmp.....you learn something new every day.

edit: wait....spoke too soon. no, 500 should not count. and the total is off. i just put it on the report and the total is reading 63 when it should read 8. let me look into this a bit more.

Edited November 17, 201015 yr by Guest

How about only looking at the last 2 digits?

If ( Right(Recommended Load Bill Count; 2) = "50" ; 1 ; 0 )

yup! that's it. and i'm stupid sometimes. the summary wasn't working because for some idiotic reason, my brain lapsed and i made it COUNT, not TOTAL.

blonde moment.