Calculated field in pivot table for % true or false

[jas86]

Hi There,

I need a calculated field to work out the "completed on time" % in my pivot table.

When i do it manually, my formula is =(D5-B5)/D5.

I want to insert a calculated field but only have it create one extra column with one result.

Thank you,

 

[GlennUK]

Are you on here twice with different logins?

Calculated Field in Pivot Table

Hi There, I need a calculated field to work out the "completed on time" % in my pivot table. When i do it manually, my formula is =(D5-B5)/D5. I want to insert a calculated field but only have it create one extra column with one result. Thank you,

www.mrexcel.com

 

[jas86]

Are you on here twice with different logins?

Calculated Field in Pivot Table

Hi There, I need a calculated field to work out the "completed on time" % in my pivot table. When i do it manually, my formula is =(D5-B5)/D5. I want to insert a calculated field but only have it create one extra column with one result. Thank you,

www.mrexcel.com

Apologies, I am. Only because I forgot a password on this account but still have it logged in on my phone. Please disregard this thread.