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
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