Skip to Content
0
Former Member
Nov 30, 2011 at 09:30 AM

Calculate a difference in a group

35 Views

Hi,

I have a little problem calculating a simple difference in a group.

For example:

I have a group YEAR with values like 2010 or 2011 and I have a table SALES where all my sales are in it, for 2010 and 2011.

I want to calculate the sum of sales for 2010 - the sum of sales for 2011. And want to show it for all hierarchies like quarters or months. And than want to be able to use it in a chart too.

In Web Intelligence It's very simple to calculate, because I can filter my data in a formular with the WHERE operator. Is there anything like this in Crystal Reports? I tried running sums or to filter my data with IF and ELSE but nothing could help me...

I hope the problem is understandable...