Problems using numerical expressions?

If you have a numeric column but are unable to use the mathematical expressions (e.g. Sum) in the dataset editor screen, it may be that the first couple of rows in your data contain a space character (i.e., they are not simply empty).

As the dashboard infers the type of the column from the first few rows, in such cases, it would 'see' the space in the first rows and will consider the column as a string format, rather than a numeric one. 

- Expression editor for an Attribute column.

- Expression editor for a Measure column.

If you are using an Excel spreadsheet source data, you could set your Excel source column to be of a 'Number' type.

Moreover, if you have a blank value (space) in the first couple of cells, you could set them to '0'.

Thus, the software will be able to detect that this column contains integers/decimals and all mathematical expressions could be applied to it.