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.
Thanks in advance.
With the attached workbook, I do not see any place where both values exist but the Deferral % does not.
Do you have a screenshot?