4 Replies Latest reply on Sep 18, 2017 10:40 AM by Francisco Monterroso

    How do I add the percent of a single cell to the value of a new column?

    Francisco Monterroso

      Hi,

       

      I have a simple table showing a total and percent of items per state:

       

      Untitled.jpg

       

      I would like to be able to create a calculated field (Percent-2) adding Percent-1 plus the percentage of "(Missing)", which is 9%. So for New York the new field should read, 54%, for NJ 19%, and so forth. Also, Percent-2 should exclude the value for the cell (Missing) so that I don't get a value of 18%.

       

      The total is 582. I have tried different approaches to this problem and nothing seems to work. Can someone please help me with this problem?

       

      Thanks,

       

      Francisco