Indicater for number in columb

Sisense generally expects there to be a form of aggregation applied in formulas. The default aggregation chosen is usually either COUNT() for (partially) non-numeric values or SUM() for numeric values. In this case, since you want to show a single value, probably you want to show the MAX(), AVG(), or MIN(), possibly appropriately filtered to exclude any rows with inappropriate values. If there is only one value, all three of those should work out to the same number...