This content has been marked as final.
Show 2 replies
-
1. Re: Is it possible to get last year total sales to compare to sales for a month in the next year
Deepak RaiFeb 8, 2018 8:10 AM (in response to Don Lay)
{FIXED:SUM(IF (Year(order Date)=(Year(Today())-1)) THEN Sales END)}
-
2. Re: Is it possible to get last year total sales to compare to sales for a month in the next year
Don Lay Feb 8, 2018 8:17 AM (in response to Deepak Rai)Thank you, That gives me last year as in only 2017 because of (Today()). I need last year for each row in the data grid. On top of this when I filter to a particular month I need it to still show the prior values which I just realized causes my LM and LY calcs to not work .