Don't get the entire row if perticuler columns are zero values..

[Kohli]

I have table. Like

  SID,  Eng,  Soc,  Sci,  Maths, Hindi, Total

  S1,   10,    12,    15,   14,  12,      63

 S2,    12,   11,     13,    12,   04,   52

S3,     0,      0,       4,      0,      0,     4

I don't want show Entire row,  if any of the 3 subjects are zero values.

[pradosh_thakur]

=pick(match(rangesum(Eng =0 ,  Soc =0 , Sci =0 ,  Maths=0 , Hindi=0),-3,-4,-5)+1,SID,null(),null(),null())

Use the above as a dimension

[pradosh_thakur]

and suppress null

[Channa]

IF((eng-=0 or soc-=0 or sci-=0 or maths-=0 or hindhi-=0), SID)

[pradosh_thakur]

Hi @Channa

not equal to is represented as  <> in the if clause and the op want's to not show the column when any of the three or more then three columns are zero. If my understanding about the op's requirement is correct he is not looking for only one value to be not zero. I am happy to be corrected.

Thanks

Pradosh

[Channa]

@pradosh_thakur  HE SYING ANY SUBJECTS having "0"  i think NOT ALL 

IF((eng<>0 or soc<>0 or sci<>0 or maths<>0 or hindhi<>0), SID)