PDA

View Full Version : Formatting (null)



nnatraj
04-10-2003, 12:25 PM
I have tried using formatString="$#,###;($#,###);$0;$0" without success. Is there any other way that I can convert (null) to 0? Thanks in advance.
Nattu.

jhyde
04-10-2003, 08:27 PM
This was fixed in change 405, on 29th March, a few days after Mondrian 0.5 was released. Get the latest code from perforce, or wait for 0.6 to be released.
An example query:
with member [Measures].[Foo] as '([Measures].[Store Sales])',
format_string = '$#,##0.00;($#,##0.00);ZERO;NULL;Nil'
select
{[Measures].[Foo]} on columns,
{[Time].[1997], [Time].[1998]} on rows
from Sales
gives
[Time].[1997] $565,238.13
[Time].[1998] NULL

nnatraj
04-12-2003, 12:00 PM
Thanks, Julian. I'll try it and let you know if it does not work.
Nattu.