"Number" format

[Bed Guy]

I'm not sure if this is the correct location to post this or not. If not,
please direct me to the appropriate group. Thanks!

I'm using the Pivottable Web part for OWC11 in Sharepoint Portal 2003. When
formating the pivot table using the "Commands and Options" menu item, what is
the syntax that I can use when formating for "Number". For example, I know
that $#,# will display the data in the currency format without any decimals.
My main goal is to be able to change the text color based on the data value,
but, I'm going to guess that isn't possible using the web part GUI editor.
If someone could direct me to the documentation that has all the syntax for
this, that would greatly be appreciated.

Thanks!

Marc

 

[Alvin Bruney [ASP.NET MVP]]

There's no documentation per se, although it is somewhere in the black book.
I think what you need is something like this "[Green] Profit [ > 100]; [Red]
Loss [ < 0]"

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $19.99

 

[Bed Guy]

Thank you Alvin for the response to my post. So, let's say I have a field
called Profit. How would the syntax look if I wanted the field to be RED if
it is less than zero or BLACK if greater than or equal to zero AND also
display in the format of $#,#?


Marc

There's no documentation per se, although it is somewhere in the black book.
I think what you need is something like this "[Green] Profit [ > 100]; [Red]
Loss [ < 0]"

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $19.99

I'm not sure if this is the correct location to post this or not. If not,
please direct me to the appropriate group. Thanks!

I'm using the Pivottable Web part for OWC11 in Sharepoint Portal 2003.
When
formating the pivot table using the "Commands and Options" menu item, what
is
the syntax that I can use when formating for "Number". For example, I
know
that $#,# will display the data in the currency format without any
decimals.
My main goal is to be able to change the text color based on the data
value,
but, I'm going to guess that isn't possible using the web part GUI editor.
If someone could direct me to the documentation that has all the syntax
for
this, that would greatly be appreciated.

Thanks!

Marc

 

[Bed Guy]

Sorry, I just saw your shameless pllug.

I will just purchase the book.

Thanks,

Marc

There's no documentation per se, although it is somewhere in the black book.
I think what you need is something like this "[Green] Profit [ > 100]; [Red]
Loss [ < 0]"

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $19.99

I'm not sure if this is the correct location to post this or not. If not,
please direct me to the appropriate group. Thanks!

I'm using the Pivottable Web part for OWC11 in Sharepoint Portal 2003.
When
formating the pivot table using the "Commands and Options" menu item, what
is
the syntax that I can use when formating for "Number". For example, I
know
that $#,# will display the data in the currency format without any
decimals.
My main goal is to be able to change the text color based on the data
value,
but, I'm going to guess that isn't possible using the web part GUI editor.
If someone could direct me to the documentation that has all the syntax
for
this, that would greatly be appreciated.

Thanks!

Marc