Hello,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
> </o>
I’ve been thinking about this for ages and just can’t think of any way around this – I’m sure someone out there must have some genius way of doing this.
<o> </o>
I’m coding some VBA to make some Calculated Fields in a pivot table each day.
<o> </o>
The Calculated Field isn’t complicated – it’s just going to add some fields together. The problem is that as the underlying data changes each day, not all the fields I want to sum will appear every day.
<o> </o>
For example:
Calculated Item ‘All Fields’ = Field 1 + Field 2 + Field 3 + Field AA + Field B
This will work fine until one day my data might not contain any entries for (say) Field 3 and the calculated field won’t work.
<o> </o>
Is there any way I can check to see if there are entries for each field I want to sum in the data, and then only sum those items that appear?
<o> </o>
Hope this makes sense. Let me know if you need anything else.
<o> </o>
Thanks for any help / suggestions / thoughts.
<o> </o>
James
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o> </o>I’ve been thinking about this for ages and just can’t think of any way around this – I’m sure someone out there must have some genius way of doing this.
<o
> </o>I’m coding some VBA to make some Calculated Fields in a pivot table each day.
<o
> </o>The Calculated Field isn’t complicated – it’s just going to add some fields together. The problem is that as the underlying data changes each day, not all the fields I want to sum will appear every day.
<o
> </o>For example:
Calculated Item ‘All Fields’ = Field 1 + Field 2 + Field 3 + Field AA + Field B
This will work fine until one day my data might not contain any entries for (say) Field 3 and the calculated field won’t work.
<o
> </o>Is there any way I can check to see if there are entries for each field I want to sum in the data, and then only sum those items that appear?
<o
> </o>Hope this makes sense. Let me know if you need anything else.
<o
> </o>Thanks for any help / suggestions / thoughts.
<o
> </o>James
