Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Dim IndxNumber as Long
IndxNumber = ComboBox1.ListIndex + 1 With Worksheets("Reps Current").PivotTables("PivotTable1") ..CalculatedFields.Add "testfieldname", "= (Total28- 'On Time28')/ Total28" ..PivotFields("testfieldname").Orientation = xlDataField ..PivotFields("Sum of testfieldname").Caption = "Percent Overdue" ..PivotFields("Percent Overdue").NumberFormat = "0.00%" End With Above is a code that creates a calculated field and inserts it into PivotTable1. The .calculatedfields line is the formula of the calculatedfield. This code works fine but instead of specifiying the eaxct pivotfields that make up the calculatedfield formula, I need for it to reference the variable IndxNumber. In this example variable IndxNumber is currently 31. So in this case instead of the formula being: "= (Total28- 'On Time28')/ Total28" it needs to say "= (Total31- 'On Time31')/ Total31" I have tried "= (Total" & IndxNumber & "- 'On Time" & IndxNumber & "')/ Total" & IndxNumber but I keep getting an error. How do I write this formula so it functions like I need? Thank you Todd Huttenstine |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula syntax | Excel Discussion (Misc queries) | |||
Need help with formula syntax | Excel Discussion (Misc queries) | |||
formula syntax. | Excel Discussion (Misc queries) | |||
Formula syntax {;;;} | Excel Worksheet Functions | |||
Formula Syntax | Excel Programming |