Traditional web-based reporting with SAS BI tools

show zero rather than "."

Reply
Contributor
Posts: 21

show zero rather than "."

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 ".".

Super Contributor
Posts: 349

Re: show zero rather than "."

Hi,

how about using condition highlighting.

Thanks,

Shivamissing.png

Contributor
Posts: 21

Re: show zero rather than "."

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

Super Contributor
Posts: 349

Re: show zero rather than "."

Hi,

You can also do by writing expression in Imap.

(case when Account_Type . then 0 else Account_Type

end) as Columnname

Thanks,

Shiva

Contributor
Posts: 21

Re: show zero rather than "."

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

Respected Advisor
Posts: 3,658
Super Contributor
Posts: 349

Re: show zero rather than "."

Hi,

Try this..I have changed your expression.

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

Thanks,

Shiva

Contributor
Posts: 34

Re: show zero rather than "."

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

Occasional Contributor
Posts: 5

Re: show zero rather than "."

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

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

Post a Question
Discussion Stats
  • 8 replies
  • 800 views
  • 0 likes
  • 5 in conversation