Show only entries with values(>0) in them (not zero or blank)

[ovetteabejuela]

Hi,

Sorry can't upload to the cloud --- I'm restricted, but here's a sample data(below). Put simply that I wanted to get the percentage Numerator/Denominator but what I want is to not show in a graph any entries that are blank percentage or zero percentage.

I already played around with HASONEVALUE but just couldn't get it to work. Any help please? Thank you.

Numerator	Denominator
14	85
33	63
88	63
0	52
33	89
12	79
28	105
0	95
34	57
7	60
76	81
27	90
49	104
65	50
0	54
16	103
82	56
62	75
0	109
57	100

[spuder · Accepted solution]

Hi @ovetteabejuela

the simpliest way is just to filter the visuals where you don't want your blank and zero values.

[ovetteabejuela]

OKay thanks, actually there are three columns that I need to check, but I think I know what I need to do now.

I'll just sum up all the three and only show those records which has greater than 0 total, meaning if atleast one of the three fields has value in it, a record should show.