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

      tia

      Vanessa