1 Reply Latest reply on Aug 14, 2013 8:38 AM by Tracy Rodgers

    Calculations with specific columns

    alexander.alcazar

      I'm completely new at using calculated fields and parameters, so I really have no idea how to do this seemingly simple operation.

       

      I have population data for 8 municipalities over 11 years, categorized into 6 age groups.

       

      What I want to do is make a calculation for the total change in population over these 11 years, both per municipality and age group but also total change per municipality and total change for all municipalities. I would like to calculate the change both in number of people and percentages.

       

      I don't think I've really grasped how these features work, because i can't figure out how to do this. I've tried things like creating one field

      if [year] = 2025 then [number of people], another field for 2011, then a third field for subtracting the first field from the second, but apparently it doesn't work that way. Help is appreciated!