This content has been marked as final.
Show 3 replies

1. Re: Calculated Fields
Alan Perez Sep 29, 2017 1:29 PM (in response to Joe Denton)you can create 2 calculated fields, one where you get the year 2017 and another where you get the 2016, and from there generate calculated fields for your operations that you want to visualize

2. Re: Calculated Fields
Jennifer VonHagel Sep 29, 2017 1:49 PM (in response to Joe Denton)1 of 1 people found this helpfulHow's this? Is it ok to hardcode 2017 and 2016 into the formulas?
FY 20172016 Dif
total(
sum(if [FY] = 2017 then [Total Surveyed] end) 
sum(if [FY] = 2016 then [Total Surveyed] end)
)
FY 20172016 Dif %
total(
(sum(if [FY] = 2017 then [Total Surveyed] end) 
sum(if [FY] = 2016 then [Total Surveyed] end)) /
sum(if [FY] = 2016 then [Total Surveyed] end)
)
Hope this helps,
Jennifer

3. Re: Calculated Fields
Alan Perez Sep 29, 2017 1:53 PM (in response to Jennifer VonHagel)can be friend is a solution