List without zeros

J_jvs
Participant V

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

thks

0 1 92
1 REPLY 1

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โ€

Top Labels in this Space