Only 30 Days Past Due on Invoice ?

  • Thread starter Thread starter Dave Elliott
  • Start date Start date
D

Dave Elliott

How can I change this so that if the Invoice is not 30 days late, it will
show the Order Amount only ?
And of course if it is 30 days late, then Total both Order Amount and the 2%
!

Thanks,

Dave

=IIf([DaysPastDue]<0,CCur([Order Amount])*0.02)+[Order Amount]
 
Just put [Order Amount] as the false clause of the IIF statement.

"=IIf([DaysPastDue]<0,CCur([Order Amount])*0.02)+[Order Amount],[Order
Amount])

Kelvin
 
DONT UNderstand ? Please give syntax so I can see what you mean !

Thanks,

Dave


Kelvin Lu said:
Just put [Order Amount] as the false clause of the IIF statement.

"=IIf([DaysPastDue]<0,CCur([Order Amount])*0.02)+[Order Amount],[Order
Amount])

Kelvin

Dave Elliott said:
How can I change this so that if the Invoice is not 30 days late, it will
show the Order Amount only ?
And of course if it is 30 days late, then Total both Order Amount and
Click to expand...
the
2%
!

Thanks,

Dave

=IIf([DaysPastDue]<0,CCur([Order Amount])*0.02)+[Order Amount]
Click to expand...
Click to expand...
 
Back
Top