Invoice Total conditional

FM 8.5
I have an Invoice List for tracking my Receivables.
I have a Value List "1 Ordered" "2 Invoiced" "3 Paid" "4 Cancelled".
How can I write a Case calculation so that the Invoice total is not
reckoned when the Value list reads "Paid" or "Cancelled"?

I thought this might work, but it does not.

Case (ValueListItems
(Status) = "1 Ordered"; TotalAmount ;
(Status) = "2 Invoiced"; TotalAmount ;
(Status) = "3 Paid"; " " ;
(Status) = "4 Cancelled"; " ")

Thanks

Re: Invoice Total conditional

In article
<76e8347e-08ca-408a-a184-330b501db37d@e10g2000prf.googlegroups.com>,
buck.matthew74@yahoo.com wrote:

> FM 8.5
> I have an Invoice List for tracking my Receivables.
> I have a Value List "1 Ordered" "2 Invoiced" "3 Paid" "4 Cancelled".
> How can I write a Case calculation so that the Invoice total is not
> reckoned when the Value list reads "Paid" or "Cancelled"?
>
> I thought this might work, but it does not.
>
> Case (ValueListItems
> (Status) = "1 Ordered"; TotalAmount ;
> (Status) = "2 Invoiced"; TotalAmount ;
> (Status) = "3 Paid"; " " ;
> (Status) = "4 Cancelled"; " ")
>
> Thanks

You don't need the ValueListItems function - this function is used to
retrieve ALL the possible items in a Value List (and in fact you're
missing some of the parameters for it, so I'm surprised FileMaker even
lets you out of the Define Calculation window).

When testing a field that uses a Vlaue List that can only be a single
answer (ie. NOT checkboxes), you simply need to compare the two as you
would with any normal field.
ie.
Case (Status = "1 Ordered"; TotalAmount;
Status = "2 Invoiced"; TotalAmount;
Status = "3 Paid"; " ";
Status = "4 Cancelled"; " ")

This shouould work as you expect ... assuming of course that
TotalAmount is being calculated correctly. :o)


Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)