My Invoice Aging reports, since translating my Q&A 5.0 Invoice database to Sesame, have gone wacky.  I use derived colums in Q&A to determine whice invoices fall into the appropriate aging colums.  After translation, the programming for these colums look like this:

Aged 0 to 30 Days=(@date-DATE_OF_INVOICE_1<31)*BALANCE_DUE 

(The original Q&A code was

Heading: 12:(0-30 Days)
Formula No. 1  (@date-#3<31)*#4
Column/Sort Spec: 5,ST,T 

The name "Aged 0 to 30 Days" is new...the original heading (0-30 Days) , because of operator characters, gave Sesame a hissy fit.

But the new name works, though the derivation doesn't.  It's being formatted as text and I have no idea how to change it to money.  Also, none of my subtotals or totals are happening.  The report shows no group footers at all.

I've just started playing with the reports; I expect many more problems and questions.  Can anyone give me a nudge in the right direction?

Thanks Ray.  Where would that code go?

Also, can I expect that none of my Q&A report subtotals and totals will carry over into Sesame's reports?

OK, but I can jam it all into one column's programming using if/then to fill them all, and delete the code from the other colums, is that correct?

For instance:

Var vDays as Int

vDays = @ToNumber(@Date) - @ToNumber(DATE_OF_INVOICE_1)
If vDays < 31 Then
{
	Aged 0 to 30 Days = BALANCE_DUE
}

Else

If vDays < 61 Then
{
	Aged 30 to 60 Days = BALANCE_DUE
}

Else

If vDays < 91 Then
{
	Aged 60 to 90 Days = BALANCE_DUE
}

Else

{
	Over 90 Days = BALANCE_DUE
}