1 Reply Latest reply: Oct 12, 2012 7:11 AM by Jonathan Ditchfield RSS

    Calculating Percentage from two expressions

      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