All zero values to be converted to nothing (just a blank row)

[nevilledhamsiri]

Dear Members,

If I am to just bring the zero value rows to just a blank row, what adjustments are possible ? Because zero values are counted as a number in the case of count. 

BRANCH	PAID	PROVIDED
RA	2500	4500
RA	3500	4700
RA	1000	4900
RA	1500	5100
RA	200	5300
RA	13500	0
RA	4500	0
EH	3500	200
EH	12500	400
EH	10000	600
EH	5000	800
RA	0	1000
RA	0	1200
RA	0	1400

Thanks in advance

Neville

[nevilledhamsiri]

Need only the zero values to be shown as blank but the total row should remain as it is with other data.

[Saravanan_Desingh · Accepted solution]

Are you looking something like this?

tab1:
LOAD BRANCH, If(PAID=0,Null(),PAID) As PAID, 
	 If(PROVIDED=0,Null(),PROVIDED) As PROVIDED;
LOAD * INLINE [
    BRANCH, PAID, PROVIDED
    RA, 2500, 4500
    RA, 3500, 4700
    RA, 1000, 4900
    RA, 1500, 5100
    RA, 200, 5300
    RA, 13500, 0
    RA, 4500, 0
    EH, 3500, 200
    EH, 12500, 400
    EH, 10000, 600
    EH, 5000, 800
    RA, 0, 1000
    RA, 0, 1200
    RA, 0, 1400
];