1 Reply Latest reply on Jul 20, 2016 3:22 PM by cor.bader

    Calculating percentage between two fields and returning blanks?

    Nabeel Mohamed

      Hi, can someone please assist me.

       

      The workbook attached reflects the total number of processed work per staff member and the total number of deferred (pending) instances per staff member.

       

      In order to get the "Deferral %", i created a calculated field dividing the one by the other and formatting it as percentage.

       

      where once of the two fields are blank, there should be an error or blank in the percentage column, which is the case.

       

      However, i cannot understand why there is no percentage displayed when both totals appear.

       

      Please help.

       

      Thanks in advance.