List without zeros

[J_jvs]

Hi Team,
how can i make a list of this column (attached) but without zeros?

thks

[Suvrutt_Gurjar]

You may wish to post more details if your are looking for something else than the approach mentioned below.

I believe you could do it in a couple of ways

1. SELECT(Table Name[fitxa], [fitxa]<>0)

OR something like below

2)Table Name[fitxa] -LIST(0)

Both the above expressions assume the column to be of Number type. If it is Text type, please put the 0 in quotes as “0”