Sum function requires numeric inputs

Hello AppSheet Community,

The select() statement below should return numeric inputs because the column only has numbers. What am I doing wrong?

Thank you :slight_smile:


1 Like

If you’ve just changed the column type for the How many samples collected? column and hadn’t yet saved the change before entering this expression, Expression Assistant won’t be aware of the new column type. In this case, save the change to the column type and re-try creating this virtual column.


That worked :slight_smile:

1 Like

That’s bitten me plenty of times…