Patricia_Zavisky Member

Comments

  • Hi Thanks. If I wanted to create in Beast mode what that formula look like?
  • Hi Mark, worked a solution. Instead of showing the value as a % of Total column in the formating of the calculation I edited the beast mode calculation - COUNT(DISTINCT(CASE WHEN Hierarchy of Control_Elimination count = 1 then Parent Record: Uniq IDEND)) / COUNT(DISTINCT Parent Record: Uniq ID) * 100 Thank you all for your…
  • Hi Mark, I have successfully created the column and the column with a zero value is appearing. I had an issue. The percentage count was not a distinct count e.g. I then created a a beast mode calculation - COUNT(DISTINCT(CASE WHEN Hierarchy of Control_Elimination count = 1 then Parent Record: Uniq IDEND)) This gave the…