Show all values in table regardless of count

[jenszulinski]

Hi,

I need to show rows for all values, regardless of count.  The table is straightforward.  This is what I need it to display:

Value        Count

Value 1       2

Value 2       3

Value 3       1

Value 4       0

I cannot get Value 4 to display.   Value 4 has no items associated with it in the report, so I'm assuming it would be 'null', but I need it to display as 0. 

I've selected the following options on format table:

"show rows with empty measure values"

"show rows for which all measure values = 0"

"show rows for which the sum of measure vallues = 0"

I've also included all values in an advanced sort

When I do a separate count on the value and display I get "Multivalue".  Here is the formula =If ([Value]="Value 4";1;0)

Neither of these options worked.  Thank you in  advance for your assistance.

[amitrathi239 · Accepted solution]

share your table screenshot.are you getting value 4 in the table and count column is blank?

If yes then right click on the count column->Formatnumber-> define the custom format.

[jenszulinski · Accepted solution]

Hi Amit,

Thanks.  Value 4 does not dispay in the table because there are no tickets associated with that value.

[amitrathi239 · Accepted solution]

add one more webi query to get all values from the Value object.Only add value object in the second query to get all values.

Merge the object at webi level and use merged object in the report.

[jenszulinski · Accepted solution]

Thank you Amit!

[Former Member]

Hllo Jennifer,

Please add 0 to your count like [Count]+0 and use that in your table and then per your current settings it will be displayed.

Regards

Niraj

[jyothirmayee_s]

Hi,

In the count formula include

=If (Isnull([Count])) then 0 else [Count]

Thanks,

Jothi

[jenszulinski]

Hi Jyothirmayee,

Thanks.  That works as a counting formula, but I need to be able to display "Value 4".  Right now the table is not displaying Value 4 because there are no tickets associated with that value.

[former_member198519]

try :

=If (isnull(Count(Value4));0;Count(Value4))

[jenszulinski]

Hi Kuldeep,

Thanks.  That works as a counting formula, but I need to be able to display "Value 4".  Right now the table is not displaying Value 4 because there are no tickets associated with that value.

[former_member198519]

add another query and bring only "Value" field and in the report use the merge object for Value.