( Total Created - Total closed ) / total created
is the formula you need if you want the percent that are open.
That does indeed result in the right amount, except it displays as a negative percent. Is there a way to make it a positive number?
I knew my math was rubbish.
D'oh. Yeah. I see why that's a silly question. Damn. Private school fails again.