Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have two separate expressions as below:
=count(callref), which gives me the total amount of calls.
=count({$<[withinfix]={0}>} withinfix), which gives me the total amount of calls where field withinfix equals 0.
What I am looking to do is create and expression in a text box to show the percentage between the field with the total amount of calls and the field where withinfix equals 0.
I have tried the below expression with no luck. Would someone be able to help please?
=sum(count(callref) / (count({$<[withinfix]={0}>} withinfix))) * 100
However this shows a NULL Value.
Regards,
Jon Ditchfield
Hi,
Please dont waste your time on this one, I have managed to figure it out.
The calculation is: =count([$<[withinfix]={0}>} withinfix) / count(callref) * 100
Hi,
Please dont waste your time on this one, I have managed to figure it out.
The calculation is: =count([$<[withinfix]={0}>} withinfix) / count(callref) * 100