Formula in a crosstab not exporting to Excel

[Extrmdressage]

Hi,
I am using CR 8.5 and I am using a formula in the crosstab to reflect service time for staff. I need to export this to Excel, however the formula does not appear in Excel when I export it. Is there a way to make the formula appear in Excel when I export? Any help would be much appreciated. Thanks in advance.

 

[LinPro]

Hi

You can't export formulas. You can only export the results of the formulas.

L

 

[Extrmdressage]

Is there a way to show all of the formulas in CR even if the data is zero? For example, I am doing a termination report for staff by service time. The service time is as follows:

less than 3 months 1
3-6 months 0
6 months to 1 year 2

In the sample above, 3-6 months will not appear because the value is zero. Is there a way to get that to show?

 

[LinPro]

Are you using the 3-6 months in a group by? Are these put in specific orders?

How did you use the months in the report?

L

 

[Extrmdressage]

Yes, they are put in specific order. I am not using any groups in the report.

 

[LinPro]

Hi

Put the months selection in a group by in specific order. this will keep the groups there even with 0's.

Make these as group by:
less than 3 months
3-6 months
6 months to 1 year

L