Need help with billing calculator - nearly there

[spikenorth]

Looking for quick help.

I've set up the following fields:

DAYS OUTSTANDING (this returns a calculated number result based on the number of days since the booking date).

late fee 1 = 22 late fee 2 = 33 late fee 3 = 66.

NOW: = Late Fee Calculated (this field should display the relevant late fee for a particular record, based on the number displayed in the DAYS OUTSTANDING field).

I am trying:

Case ( DAYS OUTSTANDING >14<31 ; late fee 1; DAYS OUTSTANDING >30<61 ; late fee 2; DAYS OUTSTANDING >60<91 ; late fee 3; )

===================================

If ( DAYS OUTSTANDING >14<31 ; late fee 1; )

If ( DAYS OUTSTANDING >30<61 ; late fee 2; )

If ( DAYS OUTSTANDING >60<91 ; late fee 3; )

===================================

Lookup ( DAYS OUTSTANDING {; If ( DAYS OUTSTANDING >14<31 ; late fee 1; )

If ( DAYS OUTSTANDING >30<61 ; late fee 2; )

If ( DAYS OUTSTANDING >60<91 ; late fee 3; )} )

===================================

Really need help on this one,

Thanks.

[comment]

Try =

Case (

DAYS OUTSTANDING > 60 ; late fee 3 ;

DAYS OUTSTANDING > 30 ; late fee 2 ;

DAYS OUTSTANDING > 14 ; late fee 1

)

[David Jondreau]

1) Comparison operators (<, >, =, etc) can can't be "stacked". It's Days>30 AND Days<61, not Days>30<61.

2) Use the first statement, the Case(), but change it per above. The way you're using If() and Lookup() doesn't make sense.

3) Learn the basics of Filemaker calculation syntax. It's not hard, but you've got misplaced semi-colons and you've got multiple functions without logical operators.

4) Change your skill level from Advanced to Entry Level or Beginner.

Edited July 19, 2010 by Guest

[spikenorth]

Thanks, it worked straight away.

[spikenorth]

I changed my user level to beginner.

I have had a look at Install OnTimer Script and notice the second(s) intervals to make use of it.

I want to write a cron job to enable a particular script to run every Monday morning at one minute past midnight.

Can you help me with this please?

[David Jondreau]

I have had a look at Install OnTimer Script and notice the second(s) intervals to make use of it.

I want to write a cron job to enable a particular script to run every Monday morning at one minute past midnight.

Can you help me with this please?

Start a new thread.