Syntax for Calculations

[DLG]

Does anyone know where can I find out the syntax for writing expressions for
calculated fields and totals in an OWC 2003 Pivot Table? This feature is
very underdocumented.

TIA
Dean

 

[Alvin Bruney [MVP - ASP.NET]]

what kind of expressions are you asking about? MDX?

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc

 

[Dean]

not trying do anything with mdx at the moment, but may want to in the
future. I am currently interested in regular formulas for creating
calculated fields using the data in the pivot table. Is it the same as in
regular excel? which excel functions, if any, can be used? I am specifically
interested in how to create a calculation to calculate a percentage and
would like to avoid displaying #num when there is division by zero.

what kind of expressions are you asking about? MDX?

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc

Does anyone know where can I find out the syntax for writing expressions for
calculated fields and totals in an OWC 2003 Pivot Table? This feature is
very underdocumented.

TIA
Dean