OWC: problem with #VALUE in Grand Total fields

  • Thread starter Michal Chmielus
  • Start date
M

Michal Chmielus

I am using OWC 11 and select some rows.
If I try using NumberFormat property for DataAxis.Totals fields and
set the format, i.e.: [Black]0.00;[Red]-0.00;[Black]0; just sets only
the blank field in Grand Total. Even if each aggregation has correct
value (not #VALUE) as grand total Pivottable component gives me
#VALUE.
Any ideas?

Michal
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Difference between 2 calculated fields showed as % of grand total 0
Difference between 2 calculated fields showed as % of grand total 0
Getting a Grand Total in Grand Total field only 3
Totals by Year 3
Problem - Show values as % of Grand total 0
Can't calculate Grand Total of several other expressions 1
row totals in pivot table 0
NumberFormat code no longer works in OWC 11 on Windows Server 2003 0

Top