List without zeros

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

thks

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”

2 Likes