Cross Tab not suppressing section expert formula

[skijop]

I am not able to suppress the counts in my cross tab for a formula called @pack. I am suppressing them successfully by using the section expert in the detail line (@pack = "other") BUT the numbers are still be shown in the cross tab that i have in the report header. I do not want them to show up bc they are messing up the totals...How can I use the same suppression on the cross tab? I tried adding the section expert suppression to the report header, but it makes my cross tab disappear.
THANKS!!!

 

[lbass]

If you want to eliminate them from both the crosstab and the report, use a record selection formula like:

{@pack} <> "other"

Or better yet, use the content of {@pack} in the record selection formula.

-LB

 

[skijop]

Thanks, Now I have the correct numbers BUT the percentages are not adding up(I put a summary field under the row count for %) The bottom total line says 100% but the other three for example say 38%, 17%, 44% which equals 99%. I right clicked on it and tried to format it but I didnt have any luck. Maybe it isnt taking into account the decimals??

 

[lbass]

These might be 38.33, 17.33, and 44.34. The results are not incorrect, but instead reflect rounding. Percentages in crosstabs have no decimals. To display the percentage with decimals, create a formula:

1 % count({@pack})

Use the sum of this formula in the crosstab instead of the percentage. Then click on the % icon in the toolbar.

-LB

 

[skijop]

My @pack formula is as follows:

if ({Command.sequence} = 13 and {Command.std_assess_id} = 11569) then "Priority Pack" else
if ({Command.sequence} = 27 and {Command.std_assess_id} = 11569) then "Welcome Pack" else
if ({Command.sequence} = 51 and {Command.std_assess_id} = 11569) then "Financial Pack" else
if ({Command.sequence} = 26 and {Command.std_assess_id} = 11570) then "Readmission Pack"

So you can see that I have 4 columns in the cross tab. By using the 1% and sum on the crosstab, it does in fact give me correct %'s but you have to add up all 4 columns and 3 rows worth of %'s to get 100%. I would like eachof my 3 row column's to show 100% in the total line at the bottom. Is there a way to do this...?

 

[lbass]

Please identify the row fields and the summary field and type of summary in the crosstab. I'm assuming that {@pack} is your only column field. Also identify your CR version.

-LB

 

[skijop]

Row field - formula {@admit}
Summary field - count of client_id
Cr version 10

 

[lbass]

You should be able to add count of client_id twice as a summary, and the second time, check "Show as a percentage of: Total count of Client_ID->From: Row.

I'm guessing this feature is available in the edit summary screen for crosstabs in CR 10.

-LB