# Number format perspective percent **URL:** \ **Category:** Ignition\ **Created:** [March 1, 2022, 4:39pm UTC](https://forum.inductiveautomation.com/t/number-format-perspective-percent/56675 "2022-03-01T16:39:44Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![zacharyw.larson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zacharyw.larson/32/23749_2.png) [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\ **Post date:** [March 1, 2022, 4:39pm UTC](https://forum.inductiveautomation.com/t/number-format-perspective-percent/56675/1 "2022-03-01T16:39:44Z")
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? edit I think I can go to the query, and format the columns there. ---
**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Post date:** [March 1, 2022, 4:53pm UTC](https://forum.inductiveautomation.com/t/number-format-perspective-percent/56675/2 "2022-03-01T16:53:32Z")
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 , , etc.` in your queries to avoid problems. In your case you’ll be doing `SELECT , 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? ---
**Author:** ![zacharyw.larson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zacharyw.larson/32/23749_2.png) [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\ **Post date:** [March 1, 2022, 4:55pm UTC](https://forum.inductiveautomation.com/t/number-format-perspective-percent/56675/3 "2022-03-01T16:55:30Z")
![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/6/860746ef467ab136271f1671934ec521c0924221.png) I was trying to follow the example on [https://docs.inductiveautomation.com/display/DOC81/Data+Type+Formatting+Reference](https://docs.inductiveautomation.com/display/DOC81/Data+Type+Formatting+Reference) I think my 8.1.0 version strikes out again though I normally use format(Counts.OEE,'P") in the query ---
**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Post date:** [March 1, 2022, 5:05pm UTC](https://forum.inductiveautomation.com/t/number-format-perspective-percent/56675/4 "2022-03-01T17:05:09Z")
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. ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [March 1, 2022, 5:26pm UTC](https://forum.inductiveautomation.com/t/number-format-perspective-percent/56675/5 "2022-03-01T17:26:56Z")
What is the actual literal value in your output, and exactly how are you configuring your transform/formatting? ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/1/213e14def3b0b83bf15dbeab8fe64edd85c1af79.jpeg) ---
**Author:** ![zacharyw.larson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zacharyw.larson/32/23749_2.png) [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\ **Post date:** [March 1, 2022, 6:01pm UTC](https://forum.inductiveautomation.com/t/number-format-perspective-percent/56675/6 "2022-03-01T18:01:48Z")
I think it is 8.1.0 issue ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/8/180fadb581b9f258e8126dc0bca437ae91095d1f.png) ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/2/e2a2ef28e84b89bd31cb754c0b043b9e15e0b9d3.png) it is in a table from a query, and I think I need to edit the query with format( ,‘P’) ---
**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Post date:** [March 1, 2022, 8:47pm UTC](https://forum.inductiveautomation.com/t/number-format-perspective-percent/56675/7 "2022-03-01T20:47:19Z")
V8.1.0 has _many_ bugs… You should definitely upgrade ---
**Author:** ![zacharyw.larson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zacharyw.larson/32/23749_2.png) [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\ **Post date:** [March 23, 2022, 6:17pm UTC](https://forum.inductiveautomation.com/t/number-format-perspective-percent/56675/8 "2022-03-23T18:17:01Z")
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