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

    Need help with billing calculator - nearly there

    NickDee

      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
          philmodjunk

          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.