6 Replies Latest reply on May 22, 2018 11:13 AM by sirisha putta

    Calculated Field for Percent of Total

    Lotte Kammenga

      Hi all,

      I am building a report with the advertising spend of competitors over time, and I want to make a calculated field for the Share of Voice of each competitor. So, for example, if the total spend was £1000, competitor A spent £500, competitor B spent £250, and competitor C spent £250, I need a field that says competitor A: 50% SoV, competitor B: 25% SoV, competitor C: 25% SoV. So it's just the individual spend of a competitor divided by the total spend that I need. Is there a way to do that?

      Thanks,
      Lotte