AnsweredAssumed Answered

Need help with billing calculator - nearly there

Question asked by NickDee on Jul 19, 2010
Latest reply on Jul 19, 2010 by philmodjunk

Title

Need help with billing calculator - nearly there

Post

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.

Outcomes