This content has been marked as final.
Show 2 replies

1. Re: How to compute percent change field for values that are computed using conditional logic around a date parameter
Tracy Rodgers Oct 29, 2013 10:27 AM (in response to Michael Polino)Hi Michael,
Do you still need assistance with this? One option may be to create additional calculated fields that find the difference between the fields, i.e.:
sum([Cost This Week])sum([Cost Last Week])
Tracy

2. Re: How to compute percent change field for values that are computed using conditional logic around a date parameter
SANDIP SHARMA Apr 7, 2017 1:24 AM (in response to Michael Polino)1 of 1 people found this helpfulHi Michael,
I believe you are looking for below output.
Your Formula:
([Cost per Metric This Week][Cost per Metric Last Week])/[Cost per Metric Last Week]
Corrected Formula:
(sum([Cost per Metric This Week])sum([Cost per Metric Last Week]))
/sum([Cost per Metric Last Week])