3 Replies Latest reply on Sep 29, 2017 1:53 PM by Alan Perez

Calculated Fields

Hello All:

I have some data with 2 years FY2016 and FY2017 under one column variable named "FY".  I need to show the difference of the Total Surveyed in my pop up, under my measures between the 2 years and I also want to show the percentage difference in the pop up.  Any ideas on splitting my FY variable into 2?

• 1. Re: Calculated Fields

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

How's this? Is it ok to hardcode 2017 and 2016 into the formulas?

FY 2017-2016 Dif

total(

sum(if [FY] = 2017 then [Total Surveyed] end) -

sum(if [FY] = 2016 then [Total Surveyed] end)

)

FY 2017-2016 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

1 of 1 people found this helpful
• 3. Re: Calculated Fields

can be friend is a solution