Forum Discussion

Kurtle's avatar
Kurtle
Helper II
6 years ago

Running Cumulative Percent

Hi team,    I am trying to get a running percent using a meaure here. What I would like to do is get a cumulative percent of Gross Gath Gas when sorted by GOR. Both GOR and Gross Gath Gas are measu...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

Try measures like this

cumm total =Calculate(Sum(Table[GOR]),filter(all(Table),table[UWI]<=max(table[UWI])))
GT =Calculate(Sum(Table[GOR]),all(Table))

Cumm % =divide([cumm],[GT])

 

Appreciate your Kudos.

Kurtle's avatar
Kurtle
Helper II
6 years ago

amitchandak I am unsure how to do this since the GOR colum is a measure so it will not allow me to sum it

cumm total =Calculate(Sum(Table[GOR]),filter(all(Table),table[UWI]<=max(table[UWI])))
GT =Calculate(Sum(Table[GOR]),all(Table))

 

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago
    cumm total =Calculate((Table[GOR]),filter(all(Table),table[UWI]<=max(table[UWI])))
GT =Calculate((Table[GOR]),all(Table))

     

    Or share the formula for GOR

    • Kurtle's avatar
      Kurtle
      Helper II
      6 years ago

      amitchandak 
      The formula for GOR is:

      GOR = IFERROR(([Gross Gath Gas E3M3/D]*1000)/[Gross Gath Oil M3/D],BLANK())
       
      Both 
      Gross Gath Gas E3M3/D and Gross Gath Oil M3/D are measures with the formulas
      Gross Gath Gas E3M3/D = Sum(Gross Gath Gas E3M3)/NumDays
      Gross Gath Oil M3 =  Sum(Gross Gath Oil M3)/NumDays
      • amitchandak's avatar
        amitchandak
        Super User
        6 years ago

        I doubt on GT , but cumm should work


        cumm total =Calculate(Sum(Table[GOR]),filter(all(Table),table[UWI]<=max(table[UWI])))
        GT = sumx(summarize(all(Table),Table[table[UWI]],"_gor",[GOR]),[_gor])