1 Reply Latest reply: Apr 12, 2017 3:58 PM by omar bensalem RSS

    Calculate Relative Percentages

    Ryan Brunet

      Hi There, I'm trying to calculate relative percentages in a table.  I'm looking at the NAICS groupings and trying to calculate the relative percentages of companies, based on a company_name field, and facility size, based on a facility_size field.  So I need to sum all of the companies that belong to that specific industry, and then divide it by all of the companies across all industries.   How might I do this?  It needs to be general, as a filter on my dashboard will be industry groupings.