show zero rather than "."

[plkkw]

I have a cross-tab report, and there are many null values in the figure of cross-tab table. In web report studio, it shows a "." for null value. It is very strange, can I change any setting to change it so that null value shows '0" (zero) rather than ".".

[shivas]

Hi,

how about using condition highlighting.

Thanks,

Shiva

[plkkw]

there is a user-defined format, can it achieve my task?

[shivas]

Hi,

You can also do by writing expression in Imap.

(case when Account_Type . then 0 else Account_Type

end) as Columnname

Thanks,

Shiva

[plkkw]

Hi shivas,

when i enter "case when <<t1.f1>> NULL then 0 <<t1.f1>> end" in expression editor of data-item through information map studio. There is error shown:

ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, <, <=, <>, =, >, >=, ?, AND, CONTAINS, EQ, EQT, GE, GET, GT, GTT, IS, LE, LET, LIKE, LT, LTT, NE,NET OR, ^=, }, }}, ~=.

ERROR 76-322: Syntax error, statement will be ignored.

** the data type of the field involved is number

[Patrick]

One of below tips should do:

http://www.sascommunity.org/wiki/Tips:Convert_MISSING_to_0

http://www.sascommunity.org/wiki/Tips:Replace_Missing_Character_Values_with_a_Character_String

[shivas]

Hi,

Try this..I have changed your expression.

case when <<t1.f1>>=. then 0  else <<t1.f1>>  end

Thanks,

Shiva

[SAPPER]

You could also try to use a coalesce function with a 0 and the column on which you are reporting

[UlfB]

To clarify SAPPER's reply, one way of fixing it is to change the expression in the infomap to:

CoalesceEmpty(<<t1.f1>>, 0)