[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Can a formula be added to a cross tab report to report a % of change of two values?

Posted on 2016-08-11
5
Medium Priority
?
50 Views
Last Modified: 2016-08-30
I have a cross-tab report that reports results of a quantity shipped and compares quarter over quarter (example: Q2 2015 to Q2 2016)
Is there a way to have the report take the value of each quarter and calculate the growth or decrease for each group and report as a percentage?

I have attached my report.
Samples-Shipped-Yr-over-Yr.rpt
0
Comment
Question by:Joe Brown
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 41752695
What version of Crystal are you using?

mlmcc
0
 

Author Comment

by:Joe Brown
ID: 41752885
XI
but I also have 2011 and could use that instead if there is an advantage to that.
0
 

Author Comment

by:Joe Brown
ID: 41753076
Here is the report in version 2011. I would like to have a column that can report % of change between the two years.

I was also wondering how I would get the data to sort in descending order by the Qty Shipped field for the most recent year (in this case 2016)
SO_Samples-Shipped-Yr-over-Yr.rpt
0
 
LVL 101

Accepted Solution

by:
mlmcc earned 2000 total points
ID: 41753845
You will have to do it in CR2011.  CR XI doesn't have the capability to create added formulas like that.  It was added in CR2008.

Try using the group sort expert.  You may have to create a formula that tests for the year and returns the value if current year otherwise 0.
If Year ({AR_InvoiceHistoryHeader.InvoiceDate}) - Year(CurrentDate) then
    {AR_InvoiceHistoryDetail.QuantityShipped}
Else
    0

Open in new window


mlmcc
0
 

Author Closing Comment

by:Joe Brown
ID: 41776787
Thank you. I will try this when I can circle back to this project.
0

Featured Post

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

650 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question