2 Replies Latest reply on Nov 8, 2016 11:43 AM by David Curtis

    How to add an extra line to a table of percentages that do not add up to 100% so they do add up to 100%

    David Curtis

      I hav data as represented below that I need an extra entry to  add up all the contents to 100%.


      How do i get a dynamic field to do that?


                               79.7%     89.4%     93.9%      92.6%      74.8%      88.2%   97.4%      96.2%    92.9%                 


      I would like an entr here that is the differerence of the percentages by column from 100%.


      I would also like to be able to add it to a stacked bar chart to show the table at 100%.


      Any ideas would be appreciated.



      My head hurts.