Recent content by diagonal76

Thanks lbass, I got quite far with this so now this works for items that have purchase orders for both years 2005 and 2006. However, when the price ({@max05price) is missing from year 2005 then CR uses the value from the previous item and so the calculation goes wrong. How could I define that...

1) I need a way to identify what is the value of field 'price' for the row with the maximum value of field 'date' within year 2005. This is to identify the item price for the last order from last year. Price 41 in the example. 2) The value of deliveries for the year 2006 is not too difficult -...

Hi, I'm trying to make some formulas to calculate some differences between prices. I have the following information: item, order date, price and delivered qty. I would then also calculate order value based on price and delivered qty. What I would like to do is to compare the last purchase...