Omit calculated results that are negative

[Joanner]

Hi,

 

I have a file that lists all outstanding invoices for vaious clients and calculates days past due on invoices over 30 days. Some of the invoices listed are not past 30 days so the result is a negative number.

 

Days past due = days - 30

 

It goes on to calculate the interest charge, which also shows a negative number. How do I make the "Days past due" calculation omit any negative numbers.

 

Thanks

Joanne

[Joanner]

I think I've got it:

 

If(DAYS

 

Thanks,

Joanne

[David Head]

I would express it this way to document the logic:

 

Let (daystopay = 30;

If ( days > daystopay; days - daystopay; 0)

)

 

In terms of documenting the logic, 'days' may not be a good field name.

[Joanner]

Thanks David,

 

You're right!

 

Joanne