Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
USING IsNull Function in PivotTable
Thanks in advance for the feedback!! I create Pivot Tables that use the
following code to create a calced field. The only problem is I get a table that has tons of zeros in it. I can't use the universal turn of zeros on worksheet because there are some zeros that don't result from a calced field that should be displayed. I was wondering if anyone knew how or if I could use the IsNull function so that resulting display would be a blank cell instead of zero. When I replace ,0 in the formula with ,"" the entire calced field disappears. ActiveSheet.PivotTables("PivotTable2").CalculatedF ields.Add _ "Weighted Avg Price", " If(PosSold 0,rev / PosSold,0)" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Test for null - insert a row if isnull | Excel Discussion (Misc queries) | |||
Having trouble with a IsNull function | Excel Programming | |||
ISNULL( ) or something else... | Excel Programming | |||
Curious IsNull test | Excel Programming | |||
ISNULL function - can't find it | Excel Worksheet Functions |