I'm trying to build a calculated True/False field. I'm struggling with creating a trailing date range to make the formula just evaluate the last 30 days.
I want to create a formula that displays:
IF in the last 30 days SUM([rev]) > 500 AND SUM([QTY]) > 10 AND the current listing price for a unit of the material is less than 70% of the last 30 day [AvgWeightedPrice] THEN "True" ELSE "False" END
I am using a standard [Date] field (mm/dd/yyyy)
Any help would be much appreciated. Thanks
Aucun commentaire:
Enregistrer un commentaire