Formula to get sales qty for specific time period 1

[travelerII]

I created a report using Crystal 10 to return the Qty sold of a product over the last 12 months.
I am using the following formula but it is returning all sales not restricting them to the last 12 months.

if {SINVOICED.INVDAT_0} >= (CurrentDate - 365) then Sum ({SINVOICED.QTYSTU_0},{ITMMASTER.ITMREF_0} )

Any help?

Thanks

 

[fisheromacse]

one way would be to limit the date range in the selection criteria.

another way would be to use variables.

//{@accumulate} placed in details section
whileprintingrecords;
numbervar suminv;
if {SINVOICED.INVDAT_0} < (CurrentDate - 365) then suminv := suminv
else suminv := {SINVOICED.QTYSTU_0};

//{@display} placed in group footer
whileprintingrecords;
numbervar suminv;

suminv

 

[travelerII]

I can't use the selection criteria because I need to also need to have sale for the last 6 months and the last 3 months.

I figure I can do it using subreports and passing the values to the main report. Just was wondering if there was a way to write a formula that would do the job.

I will give your variable method a try.

Thanks.

 

[lbass]

Your formula should be:

if {SINVOICED.INVDAT_0} >= CurrentDate - 365 then {SINVOICED.QTYSTU_0}

Place this in the detail section and insert a sum on it at the group level and/or the report level. Repeat for other intervals.

The formula you showed says: "if the current invoice date is in the last year, show me the total for the group (regardless of date)", when what you really meant was "show me the sum of those invoices that occur within the last year, by group."

-LB

 

[travelerII]

Thanks that's exactly what I needed.