how to use SELECT to get all value list incluing null

AppSheet AppSheet Q&A
1

When using SELECT expression , it will get the list which does not inlcue null. But I want to get all values, please have a check how to do it. thanks a lot

For example, using SELECT and result list is [‘100’, ‘100’, ‘100’] and actually the wanted result is [‘100’, ‘’ , ‘100’, ‘100’]

2

It looks like below expression is available but the number will be also changed to text format.

The result will show [‘1,000.00’, ‘’, ‘100.00’, ‘100.00’] which number format is based on the data setting.

SPLIT(TEXT(SELECT(TS[BSA],([_THISROW].[ID]=[ID])))," , ")

3

Your columns should be of type Decimal, and in the column properties you can set the number of decimal points to show.