How to calculate this value...???

[angelleye]

I've got invoices being stored in temporary tables prior to actually being created in our real invoices table. I have fields called InvoiceCreated, InvoiceDeclined, InvoiceOnHold. Each has a value of 1 or 0 effectively marking the status. No record would have a 1 for more than 1 of these fields.

All of that is working great. What I'd like to do now, though, is be able to figure a total amount for the declined orders. So I just need a total of all GrandTotal fields where InvoiceDeclined = 1. I could do it in a heart beat with SQL in a web app but I can't figure it out within FileMaker. I'd like to display "We've declined worth of orders." on my layout.

Any information on this would be greatly appreciated. thanks!

Edited March 12, 2007 by Guest

[mz123]

You can create a field that is a Summary field and it provides you with a Total of the Declined field.

That should do it!

[mr_vodka]

The InvoiceDeclined field is currently just used as a boolean.

You can have an additional field that is a calculation of Case ( InvoiceDeclined; Amt) and then use a summary filed to total that.

[mz123]

Ah good call. I misread her post!