Need to store grouped data

[SSonnier]

Here is what I need to do.

I have a report that keeps track of existing inventory. The report data is grouped by "style". I need to be able to show the dialy change in inventory ie:

Group Number in Stock Today Change in last day
Group A 100 in stock -10
Group B 50 in stock +2

What is the best way to do this. My formula's have not worked.

Thanks!!

 

[SSonnier]

i am thinking that something like this would work


if {orders.DATE} >= currentdate-1 then
Sum ({items.QTY},{items.PRODUCT_ID} )

 

[lbass]

I think you could use a record selection formula that includes yesterday's and today's dates:

{table.date} in currentdate-1 to currentdate

Then insert a running total {#yesterday} using the running total expert:
Select {items.qty},sum, evaluate based on a formula:

{table.date} = currentdate-1

Reset on change of your group field.

Create a second running total {#today} like the first, except change the formula to:

{table.date} = currentdate

Then you should be able to create a formula {@change} to be placed in the group footer:

{#today}-{#yesterday}

-LB