
Hi Natalie,
do you need to count active, closed and total number of clients first or do you already have that numbers?
If you already have that numbers, here an example:
var total = 200;
var active = 25;
active / total * 100
result is 12.5.
If you need to count them first all clients should be related an app with one item. Then in that item ("Status" stand for the field where you mark them as "Active" or "Closed", replace Status with the real name of that field):
var status = @All of Status;
var total = status.length;
var active = status.filter(function (i) {return i == "Active";}).length;
var closed = status.filter(function (i) {return i == "Closed";}).length;
Then you can calculate the percentage.
active / total * 100
or
closed / total * 100
Rainer