Anyone got any suggestions for dealing with scientific notation numbers in appsheet? I would like scientific notation to be displayed, instead of a very large number. My first thought was just to have them be inputted and text strings, but then a small number of these fields will optimally need to be added together, thus they would have to be numbers. Does appsheet know how to handle this? I canโt seem to find anything info about it.
Try converting the columns back to numbers when you have to calculate them. Something like NUMBER([column w/number as text]) + NUMBER([column w/number as text])โฆ
@Michael Good suggestion, didnโt see that function existed yet.
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |