I have a crystal report sub report. In this sub report I list items in inventory based upon their expiration date. I have tried all ways to create a formula to calculate the following example:
Lot # Exp. Date Qty
123 01/28/09 10
124 03/01/09 12
125 12/28/09 10
So what my formula I want to accomplish is this, if the expiration date is greater than the current date then I want to have you add these values. So for this example I would add lot 124 and 125 and come up with a total of 22.
I have went through about every possible formula I could think of and I haven't been able to quite accomplish the value of 22 I am trying to acheive. I am really wanting to say if the date has not exceeded add those lines together. If it has exceeded the current date then ignore the number in your calculation.
If anyone has an idea on how to accomplish this with a formula I would greatly appreciate it.
Thanks in advance.