Days constraints in crosstab table

[surad]

How Can I setup and display in Crosstab the following constraints 1. 60 days or more 2. Between 30 to 60 days 3. 30 days or less in one table.

Thanks,
Yuri

 

[synapsevampire]

You can create a formula which contains:

If {table.date} > currentdate-31 then
"30 days or less"
else
If {table.date} <= currentdate-31
and
{table.date} >= currentdate-60 then
&quot;30 to 60 days&quot;
else
If {table.date} < currentdate-60 then
&quot;60 days or more&quot;

and use that.

It's hard to say though, you'd be better served to supply example data and expected output.

-k

 

[surad]

Other conditions are by castypes, case open. Output should show how many cases of particular case type have been open each time period (eg. 30 to 60 days).

- Thank you