13 Replies Latest reply on Oct 5, 2016 8:59 AM by Robert Prince

    Lookup function on calculated fields

    Robert Prince

      Hi,

      I have a small attached workbook in which I need to create a calculated field that compares the "Percent of Population" field in the left pane to the "Percent of Population" in the right pane.

      For example, on the African-American line, it should be 3.47% / 1.48% for a resulting value of 2.34.

       

      I'm trying to use the lookup function but I can't make it work.

       

      Please help.

       

      Thanks!