Changing computed field in Access 2010 Pivot Table

[hise0001]

So... I have the pivot table with the following columns...



Sum of Numerator, Sum of Denominator, and a computed field for Rate

My Rate calculation is: iif(Denominator = 0, Null, Numerator/Denominator)...

I have at least 15 of these rates (numerator, denominator, rate) on the same report...

it works fine, but my business analyst has clarified the Rate requirement that if the denominator is 0 then the Rate should display 0 (instead of Null)..

When I change my Rate computed field to iif(Denominator = 0, 0, Numerator/Denominator) and press the "Change" button all the numerators and denominators on the pivot table are blanked out... I've refreshed the pivot table and everything; but, I can't stop this from happening.

Any help would be greatly appreciated.

Maybe for another thread; but, why the heck can't Access' pivot table be as robust as Excel's ???

[June7]

That's why MS partially removed support for pivot tables/charts with Access 2013 (cannot build them in Access 2013). Expect you to export data to Excel and do the calcs there.

I've never used pivot tables/charts in any db so I know only a little about them from helping posters. If you want to provide db for analysis, follow instructions at bottom of my post.