Skip to Content
0
Former Member
Apr 23, 2014 at 03:05 PM

How to find current month, previous month Net Sales by means of formula?

3735 Views

Hello Gurus,

I need my crystal report to display data as below:-

Net Sales

PG1 Current month Previous Month Prior year-month %Variance

Panels $ $ $

Frames

Can anyone kindly suggest formula for generating these values?

I have already formulated current, previous, prior year months' start dates and end dates.

Further details:-

Data filters are requested for Company-->Region-->Customergroup-->All Product group

Datasource is Universe

Reporting for 2 years data

Your suggestions and help will be much appreciate.

Thanks,

Prarthana