2 Replies Latest reply on Nov 29, 2016 7:42 AM by Walt Reed

    Quick Calculation: Percentage of Difference from First

    Siang Li Chua

      Hi.  My total population is the same 550 people who did a yearly survey.  Pls see the chart below.  I am trying to add an annotation on the difference between those responded "Yes" in Year 2016 and Year 2012.  So I use quick calculation (see pic further down). I am  expecting 482 - 428 = 54.  But somehow 360 is given.  Similarly, I want the % of difference and expecting 54/550 = 9.8% but a wrong 295.1% was given.  What should I do to get the correct computation?  Thanks much.