Only 30 Days Past Due on Invoice ?

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]
 
K

Kelvin Lu

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
 
D

Dave Elliott

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

0-30 days Past Due Invoice Formula Not Working, Help ! 2
30,60,90 Days Due. 0 to30,31-59,60-89,90-120. 4
30 Days Late on Invoice Question ! 7
Style Header Reformatted 3
Subform If Function 2
Looking for a way to Force Successor Task to next workday IF 'x' amount of time left in workday 0
Avoiding Leads, using SVT, and Linking Tasks correctly 0
Sum of items in a column if they meet two criteria in another colu 6

Top