Good day to all:
I created a calculated field for the last 3 months
if [Date Shipped] >= (DATEADD('month', -3, today())) and [Date Shipped] <= (DATEADD('month', 0, today())) then [Freight Charges] END
How could I modify this formula to calculate same period a year before?
Any suggestions
Much appreciated!
2 answers
Hi @Michel Khennafi
Did the above solution solve your question?