I have a pivot table and I have two numerical fields call enrol and total.
I want to create a % of enrol by dividing enrol by total. Which is fine, but if enrol or total has 0, then #value is being returned.
Rows in the Pivot Table is Location and columns has Main.
I've tried the following without success.
=IFERROR(enrol/total,0)
=IFERROR(IF(OR(enrol =0,total =0),"",enrol /total),"")
Desired result is to have blank rather than 0% or #VALUE
I want to create a % of enrol by dividing enrol by total. Which is fine, but if enrol or total has 0, then #value is being returned.
Rows in the Pivot Table is Location and columns has Main.
I've tried the following without success.
=IFERROR(enrol/total,0)
=IFERROR(IF(OR(enrol =0,total =0),"",enrol /total),"")
Desired result is to have blank rather than 0% or #VALUE