This content has been marked as final.
Show 2 replies

1. Re: Creating single calculated value per state?
Tracy Rodgers Apr 18, 2013 2:01 PM (in response to John Bencina)Hi John,
One way that this can be done is to create three calculated fieldsone to find the values of the last 4 weeks, one to find the values of the last week and the percent difference.
Order Quantity of Last 4 Weeks:
if [Order Date]>=DATEADD('week', 4, today()) and [Order Date]<=today() then [Order Quantity ] end
Order Quantity of Last Week:
if [Order Date]>=DATEADD('week', 1, today()) and [Order Date]<=today() then [Order Quantity ] end
Percent Difference:
(sum([Order Quantity of Last Week])sum([Order Quantity of Last 4 Weeks]))/sum([Order Quantity of Last 4 Weeks])
Hope this helps!
Tracy

2. Re: Creating single calculated value per state?
John Bencina Apr 25, 2013 6:40 AM (in response to Tracy Rodgers)Thanks!