I am wondering if anyone can help me sort out how to calculate a few values related to shelf life?
In SQL Server I use the following 2 formulas to calculate % of shelf life left and the date at which the material reaches 75% remaining (this is a customer driven cutoff for usage)
cast(((History.ExpiryDate-History.ProductionDate)-(getdate()-History.ProductionDate))as float) / nullif(cast((History.Expirydate-History.ProductionDate)as float),0)as ‘% Left’
cast(((ExpiryDate-ProductionDate))as float)*.75+ProductionDate as ‘25% Date’
I have been trying for several hours but can’t seem to figure out how to do this in the version of Combit (List & Label 21), which is built into our Power Pick Global software.