1 Reply Latest reply on Jul 19, 2010 8:17 AM by philmodjunk

# Need help with billing calculator - nearly there

### 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.

• ###### 1. Re: Need help with billing calculator - nearly there

Try this case function:

Case ( Days Outstanding < 22 ; 0 ;
Days Outstanding < 33 ; late fee 1 ;
Days Outstanding < 66 ; Late fee 2 ;
Late fee 3 )

Case statements will return the second value in the parameter pair (0, late fee 1, late fee 2 ...) of the first expression that evaluates as true.