Question

Asked on 2010-09-22 at 11:16:35ID: 26756457

Crosstab Percentage -

by: Shamanth500

Rating6.0Good

I am trying to calculate percentage in a Crosstab. But I am getting wrong results. Here is the report format

                          Actual            Target    Percentage

North East           100                80             25%

South East          200               120             67%

West                   200               180             11%

Central                200              250            -20%

-----------------------------------------------------------------------------------

Here is the formula for Percentage. This formula gives wrong results in Crosstabs. But gives correct results if used in a Sub-Report or main report. It has Percentage Difference calculation.
((sum({@Actual},{REGION}) - sum({@Target},{REGION})) / sum({@Target},REGION}))*100

  1. Applying group sum to higher level
    Hi, I have a report in CR2008 where …
  2. Crosstab with year to year net change & percen…
    I'm new to Crystal (using XI) and trying to wr…
  3. Stacked bar chart - Show percentage of total a…
    I have created a report that displays production …
  4. Losing my hair
    This question is related to the previous question…
  5. I need sum summaries
    I have created a commission report and grouped …

Solution

Access this solution immediately by signing up as a member of CrystalReportsExperts.com--it’s quick, easy, and secure. We will return you to this solution, unlocked, when you’re done.

About this Solution

Sign up Now to View This Solution
Zone
general
Tags
Participating Experts
2
Solution Grade
A

Replies

 by: Shamanth

Posted on 2010-09-22 at 11:22:38ID: 34646516

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: PCIIain

Posted on 2010-09-23 at 00:48:02ID: 34646517

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: Shamanth

Posted on 2010-09-23 at 06:15:45ID: 34646518

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: PCIIain

Posted on 2010-09-23 at 06:21:43ID: 34646519

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: GJParker

Posted on 2010-09-23 at 06:27:09ID: 34646520

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: PCIIain

Posted on 2010-09-23 at 06:30:17ID: 34646521

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: GJParker

Posted on 2010-09-23 at 06:35:59ID: 34646522

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: Shamanth

Posted on 2010-09-23 at 06:38:19ID: 34646523

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: GJParker

Posted on 2010-09-23 at 06:41:00ID: 34646524

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: Shamanth

Posted on 2010-09-23 at 06:48:57ID: 34646525

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: GJParker

Posted on 2010-09-23 at 06:55:58ID: 34646526

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: Shamanth

Posted on 2010-09-23 at 08:22:30ID: 34646527

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by:

Posted on 2010-09-23 at 09:50:43ID: 34646528

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: Shamanth

Posted on 2010-09-23 at 11:03:44ID: 34646529

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: Shamanth

Posted on 2010-09-23 at 11:08:43ID: 34646530

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: Shamanth

Posted on 2010-09-23 at 19:48:13ID: 34646531

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: Shamanth

Posted on 2010-09-23 at 19:52:57ID: 34646532

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: GJParker

Posted on 2010-09-24 at 01:36:40ID: 34646533

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: Shamanth

Posted on 2010-09-24 at 09:39:30ID: 34646534

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

Log In

Forgot your password?Sign up

Stay Connected

Top Experts

  1. mlmcc

    334,774

    Wizard

    0 points yesterday

    Profile
  2. James0628

    70,696

    Master

    0 points yesterday

    Profile
  3. LinInDenver

    4,800

    0 points yesterday

    Profile
  4. peter57r

    4,000

    0 points yesterday

    Profile
  5. 13598

    3,520

    0 points yesterday

    Profile
  6. PCIIain

    1,700

    0 points yesterday

    Profile
  7. RickIsWright

    400

    0 points yesterday

    Profile
  8. Dan3D

    300

    0 points yesterday

    Profile

BrowseAre you an Expert?