Need number calculation on found set if field is "no"

[Adam in Santa Monica]

Hey everyone. Seeking help on the below.

I have an summary field of 'amount' field. Works fine.

Now my boss wants additional summary field that shows total of only the records in found set that have "NO" in a particular field (in this case - 'client paid').

I have no idea. I was thinking of having it first do a search on the found set, along with the NO, then put then summary amount in the field as a global, then do the regular search without the NO.

Any advice would be greatly appreciated. Thanks!!

-adam the new guy

[bcooney]

Hi Adam,

Welcome back to the world of FM Development.

How about another amount field that only calcs if the client has paid, then sum that field? If (clientStatus= "paid", amount, 0).

Also, if you're just setting this up, consider a DatePaid field, rather than a "hard-coded" No in client paid field. Then calc would be:

AmountPaid = If ( not IsEmpty (Date_Paid); amount; 0)

[Adam in Santa Monica]

THANK YOU!! Woohoo! It totally makes sense, and I remember that type of logic ... its coming back to me now...

The program is so much more robust than the early versions... I am sure I'll have more questions coming up.

Again - thanks!

-adam

[bcooney]

Glad to help. I'm sure you'll receive lots of excellent help here.