CR XI - Cross Tab DATA formula help pleaes

[OrionStar]

I need help pls.

I have ACCOUNTS RECEIVABLE data pulled for ALL of our clients and all agings. I have an aging formula setup to give me columns of >30 days, >60 days,> 90 day, >120 days, ..all the way up to >720 days....

I would like to have a single cross tab column...(this can be a separate crosstab) inserted that will give me A SINGLE OVER 90 DAY COLUMN and omit all other agings.

I know that I can use the SELECT expert to limit my ENTIRE reporting detail to only show the OVER 90 days items, but I need all the other dates there too. I'm actually trying to create a single column IN ADDITION to the above columns. What I do is export this data to EXCEL for further manipulation.

Any help would be appreciated.

Here's the formula I use to separate my columns.

if {AHV_BillingsJournal.Accounting_Date_Display}< dateadd("d",-720, currentdate) then ">720 days" else
if {AHV_BillingsJournal.Accounting_Date_Display}< dateadd("d",-540, currentdate) then ">540 days" else
if {AHV_BillingsJournal.Accounting_Date_Display}< dateadd("d",-360, currentdate) then ">360 days" else
if {AHV_BillingsJournal.Accounting_Date_Display}< dateadd("d",-180, currentdate) then ">180 days" else
if {AHV_BillingsJournal.Accounting_Date_Display}< dateadd("d",-120, currentdate) then ">120 days" else
if {AHV_BillingsJournal.Accounting_Date_Display}< dateadd("d",-90, currentdate) then ">90 days" else
if {AHV_BillingsJournal.Accounting_Date_Display}< dateadd("d",-60,currentdate) then ">60 days" else
if {AHV_BillingsJournal.Accounting_Date_Display}< dateadd("d",-30, currentdate) then ">30 days" else
if {AHV_BillingsJournal.Accounting_Date_Display}< dateadd("d",+29, currentdate) then "Current" else "Unknown"


I would like a separate crosstab to ONLY SHOW over 90 days and omit all other days? IS this possible?



Thanks:

MV

"What would you attempt to do... if you knew ... you could not fail?

 

[lbass]

Why not add a higher order column using a formula like this:

if {AHV_BillingsJournal.Accounting_Date_Display}< dateadd("d",-90, currentdate) then ">90 days" else "<= 90 days"

Then you will have a subtotal column that you can use in Excel without having to add a separate crosstab.

If you really want a separate crosstab, you could use the same formula->group option->specified order->choose >90 days and then select the other tab and check "discard all others".

-LB

 

[OrionStar]

AHHHH the latter is what I need....THANKS I'll DISCARD...

THX

Thanks:

MV

"What would you attempt to do... if you knew ... you could not fail?