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?