Perspective Table default number format

Ignition
,
1

Hi all,
I use a Perspective table to show the result of a dynamic query. That resultset may have different data types at the same column index, depending on which query options the user enables - e.g. column X could be a product name as well as a decimal number representing a quantity. My quantities are as small as 0.xxxE-7, but I cannot use the columns prop to format those numbers, because the query is dynamically built. Is there any default number format I can set anywhere in the table props, which is then used for any number, wherever it might show up?

Thanks in advance, regards

2

Use an expression structure to generate both data and columns props dynamically.

3

Thanks pturmel, I was thinking to go that way, but I thought it to be too complicated for my use case.