Improve company productivity with a Business Account.Sign Up

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

Evaluate Group Summaries against each other in Crystal Reports

I have a report with summaries on a group.  I cannot figure out how I can evaluate the group summaries against each other.  Specifically, I have two values in each row, 'dollar amount' and 'year'.  In my group header/footer I have a sum total of 'dollar amount' grouped under each 'year'.  So I can have a total for 2012 and a total for 2013.  I can even do a grand total for 2012 and 2013 together, but how do I create a calculation where I get the difference of 2013 minus 2012?
0
Jake Pratt
Asked:
Jake Pratt
1 Solution
 
mlmccCommented:
I can think of 2 methods.

1.  Use variables to save the summary values then calculate the difference.

2.  Create 2 formulas
LastYear
If Year({DateFIeld}) = Year(Currentdate) - 1 then
    {AmountField}

ThisYear
If Year({DateFIeld}) = Year(CurrentDate) then
   {AmountField}

Those formulas can be summarized anywhere to get the totals for LastYar and ThisYear and then a difference can be calculated

Sum({@ThisYear}) - Sum({@LastYear})

mlmcc
0
 
Jake PrattAuthor Commented:
Now why didn't I think of that?!  Very nice.  Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

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