2 Replies Latest reply on Mar 22, 2017 10:48 AM by Jesus Resendiz

    Smart reporting percentage

    Jesus Resendiz
    Jesus Resendiz Mar 21, 2017 5:00 PM
      Share This:

      Hello I'm creating a report in smart reporting but I have a doubt about calculate percentage.

       

      For example:

      I create a report with the next section (Priority) and with the next Columns and rows.

       

       

      In this case the count are correct for Total incidents, Total Open Incidents and Total Closed incidents, but when I try to calculate the percentage This always return 100%.

       

      I'm calculate the percentage with the next funtion.

       

      COUNT ( CASE WHEN Estado General__c = 'Closed' THEN ID Incidencia__c END ) / COUNT ( ID Incidencia__c )

       

      Do you know any other form to calculate the percentage.

       

      Additional I try to use the Pre-Defined function to calculate percentage and this require Numerator and Denominator, but this not permit select Calculated fields only number fields, have any form to select Calculated fields?.

       

      Regards.