Formula

T

Todd Huttenstine

IndxNumber is a variable.

With Worksheets("Reps Current").PivotTables("PivotTable1")
..CalculatedFields.Add "testfieldname", "= (Total &
IndxNumber - 'On Time28 & IndxNumber')/ Total28 &
IndxNumber"
..PivotFields("testfieldname").Orientation = xlDataField
..PivotFields("Sum of testfieldname").Caption = "Percent
Overdue"
..PivotFields("Percent Overdue").NumberFormat = "0.00%"
End With

How do I specify this in the code? When I put &
IndxNumber, the code does not like it.
 
Top