5 Replies Latest reply on Nov 21, 2018 8:40 AM by ShivaRam Chennapragada

    Inverse of Percentage(%)

    Vanessa van Gelder

      I have a measure


      Scheme Load factor per year = sum([Output])/(sum([Station Max Output MW] *365.25*24/1000)) - this is plotted by year and group


      I want to create the inverse of the % created from this called Lost Opportunity



      Lost Opportunity

      Total(Scheme Load factor per year) / Scheme Load factor per year


      I saw this as the solution in a post on here, however this is not giving me the inverse result


      please help