pivot table summing %'s

My pivot table is summing the current AR%.  If I exclude it from the pivot & try to insert a calculated field it won't allow me because my "data type" isn't specific to acct receivable & sales.  Been...