Calculate Yearly Sales Difference

Hello,
I've been using Crystal Reports a little bit for about a year now, but have never created a report like this.

The report I am working on displays:
CUSTOMER
2005 SALES $000000.00
2006 SALES $000000.00
TOTAL SALES $000000.00
$ DIFFERENCE $000000.00
% DIFFERENCE $000000.00

I am able to bring up the yearly sales and total sales, but I cannot figure out how to calculate the difference. Any help will be greatly appreciated.

Thank you.I think you must create a query in command query in database expert:
one command query for select sum(sales) from tablename where year=2005 group by year... also another command query for 2006 and compute the difference between the two field in report using formula.

i know it is not nice suggestion but if you have no other idea then try this.|||Thanks for the idea.
I'll take a look and see if I can get it to work.sql

Calculate mean meadian and mode?

Hi all
Is there a way to calculate mean, median and mode as in Crystal? If so could
you point me to a source, I am not much on programming but willing to give
that a go if I have to.
thanks.In the current release of RS there is not a way to do this - I'm not sure if
RS 2005 will have this capability.
I had to calculate median values for a report that I designed and ended up
having to do the calculations in a stored procedure that my dataset was
using. You stated that you're not to up on programming so I'll tell you the
theory behind what I did and if you want the source I'll be glad to send it
to you.
Basically to get the median value for a dataset what you need to do is total
up the number of rows for the dataset/table and divide by 2. Once you have
that value all you have to do then is go in and retrieve the value that
resides at that row number and that will give you the median value.
hth,
Bill Youngman
Anexinet, Inc.
"darwin" <darwin@.discussions.microsoft.com> wrote in message
news:A6FD67C6-41BE-43A9-B89C-F690EDE564D4@.microsoft.com...
> Hi all
> Is there a way to calculate mean, median and mode as in Crystal? If so
could
> you point me to a source, I am not much on programming but willing to give
> that a go if I have to.
> thanks.
>

Calc % in crystal detail againt running total

Quick question.
I have a grand total being calculated in a formula, for each detail line I am trying to get a percentage of that number against a value in the detail. The problem is that the grand total is running and only calculates against the current running total not against the grand total when the report finishes. Any way around this?Hi!

1) Insert the Formula Field from Report Design Page

2) Named as Percentage and write the code to the formula field coding area

{table.numberfiled}/100

3) And Drag and Drop the Formula Filed on Details Section Where do u want place.