Max Date Formula 1

[strom99]

I have a report that shows a number of loads for a specific product. These loads tell what is happening as far as the qty of the product. The last load produced with the latest date tells me what the current inventory of that item is. I need a formula that will allow me to display this, ie display inv_qty where trans_date is max. It would display properly in the report if I had it sorted, but there are many locations of these loads and the report shows by location. Any ideas?

 

[blom0344]

Use extended syntax like:

variable1:
=max(<transdate>) in (<location>)

variable2:

=if(<variable1>=<transdate>) then 1 else 0

Use an alerter to mark inv_qty for values of 1 of variable2



Ties Blom
Information analyst
tbl@shimano-eu.com

 

[blairclw]

Ok, hopefully this will be easy for you guys.......

I'm creating a report that includes:
Employee Name
Position
Next Review Date.

When I include the Next Review Date it pulls all past review dates and I only want the greatest date. So if the next review is due 12/05/2005, that is what I want to show and not the ones from 2004, 2003, etc.....

When i do a max formula on "Next Review Date" it scans the WHOLE report and gives ALL employees the same date. I want the greatest date for each employee and it will be differant for everyone.

I'm using CR9

 

[dbomrrsm]

you need to group by employee name or better employee id

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]