If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Creating Aging Buckets in a CrossTab Report

Started by mjf, 16 Mar 2011 07:01:43 PM

Previous topic - Next topic

mjf

I'm struggling with trying to get an aging report created for unassigned CorpCard transactions using a crosstab.

I have employees set up as the rows, transaction dates set up as the columns and the transaction amount as the measure.

I'm currently using a case statement (below) to define the columns, but I get nothing back when I run the report.

Any help is appreciated.  Thanks.

case
when _days_between(current_date,[Transaction Date]) < 31 then ('0-30')
when _days_between(current_date,[Transaction Date]) >= 31 AND _days_between(current_date,[Transaction Date]) <= 60 then ('31-60')
when _days_between(current_date,[Transaction Date]) >= 61 AND _days_between(current_date,[Transaction Date]) <= 90 then ('61-90')
when _days_between(current_date,[Transaction Date]) >= 91 AND _days_between(current_date,[Transaction Date]) <= 120 then ('91-120')
when _days_between(current_date,[Transaction Date]) >= 121 AND _days_between(current_date,[Transaction Date]) <= 150 then ('121-150')
else ('>150')
end

PRIT AMRIT

I tested the same case statement and working fine.

It should work. Not sure though what's going wrong at your end. I hope you can see the Tabular Data? If yes, can you nest the [Transaction Date] item above your calculated item in Cross tab column and see whats happening?

Thanks