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
45 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 500 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

726 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