Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 55
  • Last Modified:

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

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
Joe Brown
Asked:
Joe Brown
  • 3
  • 2
1 Solution
 
mlmccCommented:
What version of Crystal are you using?

mlmcc
0
 
Joe BrownAuthor Commented:
XI
but I also have 2011 and could use that instead if there is an advantage to that.
0
 
Joe BrownAuthor Commented:
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
 
mlmccCommented:
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
 
Joe BrownAuthor Commented:
Thank you. I will try this when I can circle back to this project.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now