on 06-15-2016 1:52 PM
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
In the count formula include
=If (Isnull([Count])) then 0 else [Count]
Thanks,
Jothi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
try :
=If (isnull(Count(Value4));0;Count(Value4))
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.