trying to establish a % rate for Renewals and Retention using CountD but canot seem to get the calc to work.
In my dataset I have a field name ''Amended Licenc Action '' that has a number of components to it- I can get a CountD on the total field itself but when I try to calc my Renewal Rate or Retention rate off this field the CountD does not seem to work, a Count though works fine.
For say Renewals there are certain actions with this ''Amended Licence'' field that make it up, again same for Retention rates.
On their own I can get the CountD but as you will see from the attached workbook my % are all over the place for the rates I need to assign.
Any ideas or help with a table calc to allow CountD go across various fields
This is not a case where you need a table calculation. Instead, you can do determination of renewed or not at the row level, then do the COUNTD only on the renewals:
COUNTD(IF [Amended License Renewal Action] = "Renewed" THEN [End_Customer_ApplixID] END)
This gets the 587 number that can be divided by the count to generate the %.