3 Replies Latest reply on Nov 9, 2018 6:31 AM by Tim Dines

    Weekly Percentage (Google Sheet input)

    Inna Arabadzhieva

      Hello,

       

      I have a  question that I hope is relatively simple. My datasource is an SQL query that is joined with a Google Sheet.

       

      From the Google Sheet I only need to get a percentage that is added per week:

       

      Then this percentage is used in a calculation (see below). The problem is that for the weeks that have a change in percentage, I get the * sign,

       

      Is there a way to separate the weeks properly and display only one percentage number?

       

      Thank you in advance!

       

      Best,

      Inna