trying #0.00’%’ in a table from a query that used Select *
getting 350.00000% instead of 3.5%
It is multiplying by 100 even though I am using the quotes.
Is this because I am writing it wrong or 8.1.0 doesn’t do this?
I think I can go to the query, and format the columns there.
3.5 is 3.5 per unit = 350 per hundred = 350%.
If you want to display percent and your SQL is in units then you’ll need the SQL query to divide by 100.
It’s generally bad practice to use
SELECT * because stuff breaks if you add or delete fields from the database. Use
SELECT <field1>, <field2>, etc. in your queries to avoid problems. In your case you’ll be doing
SELECT <field1>, prodCount / 100 AS Count, etc.
or similar. Then you can format.
You can check my first statement in Excel. Type 3.5 into a cell and then format it as
%. What’s the result?
I was trying to follow the example on
I think my 8.1.0 version strikes out again though
I normally use format(Counts.OEE,'P") in the query
Ah, right. I hadn’t seen that before.
You might add a Vision or Perspective tag to your original question in case it makes a difference.
What is the actual literal value in your output, and exactly how are you configuring your transform/formatting?
I think it is 8.1.0 issue
it is in a table from a query, and I think I need to edit the query with format( ,‘P’)
V8.1.0 has many bugs… You should definitely upgrade
I need to document how I resolved this.
Same issue today.
format( ,‘P’) in the query, has 0.##% in the column
I submitted request to upgrade ignition version haha thanks for reminder