Forum Discussion

Kurtle's avatar
Kurtle
Icon for Helper II rankHelper 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
Icon for Super User rankSuper 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
Icon for Helper II rankHelper II
6 years ago

I get the following error message when trying that