1 Reply Latest reply on Feb 18, 2016 11:10 AM by Daniel Vincent

    Table Calc and LOD nightmare

    Tom Barnes

      Hello Community! I have been tasked with taking an online survey and dig deeper into the demographics.  I would like to do a comparison with each of the demographics compared to the whole and by using table calcs I can see a % of Total surveyed chose each of the 3 questions for each attribute of the chosen demographic type (in this case gender/age).  What I need to do is take the % surveyed as whole and subtract that % by the percent of each attribute of the demographic to see if there was a certain age group that liked a certain answer more than the whole.

       

      Example:

      As you can see my 3rd row doesn't calculate correctly.  I need it to be 46.30% - 43.42% which should be 2.88%

       

      Workbook attached.