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
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])

    • Kurtle's avatar
      Kurtle
      Helper II
      6 years ago

      I get the following error message when trying that