# Perspective Table numberFormat Percentage multiply by 100 **URL:** \ **Category:** Ignition\ **Created:** [August 7, 2020, 8:48am UTC](https://forum.inductiveautomation.com/t/perspective-table-numberformat-percentage-multiply-by-100/37492 "2020-08-07T08:48:52Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Brett\_Yeomans](https://avatars.discourse-cdn.com/v4/letter/b/35a633/32.png) [@Brett\_Yeomans](https://forum.inductiveautomation.com/u/Brett_Yeomans)\ **Post date:** [August 7, 2020, 8:48am UTC](https://forum.inductiveautomation.com/t/perspective-table-numberformat-percentage-multiply-by-100/37492/1 "2020-08-07T08:48:52Z")
What was the outcome to having a percentage suffix? Like the forum entry below if I select % for my column it multiplies the value by 100. > [@\[BUG-13805 & BUG-13804\] Perspective - Table issues (percentage and header justify)](http://forum.inductiveautomation.com/t/bug-13805-bug-13804-perspective-table-issues-percentage-and-header-justify/24472): > > I’m using the nightly update from last Friday (b2019042602) Issue 1 - percentage: I’ve been trying to make the column to show a number in a range 0-100 to just add the percent sign but it always multiplies by 100, regardless of single/double quotes and space. I would think it shouldn’t multiply if it has quotes around the percent sign. Am I missing something? [https://docs.inductiveautomation.com/display/DOC80/numberFormat](https://docs.inductiveautomation.com/display/DOC80/numberFormat) Screenshot: Issue 2 - table header justify: the property ju… ---
**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:** [August 7, 2020, 2:55pm UTC](https://forum.inductiveautomation.com/t/perspective-table-numberformat-percentage-multiply-by-100/37492/2 "2020-08-07T14:55:28Z")
Split this topic on August 7, 2020, 2:55pm UTC A post was merged into an existing topic: [[BUG-13805 & BUG-13804] Perspective - Table issues (percentage and header justify)](https://forum.inductiveautomation.com/t/bug-13805-bug-13804-perspective-table-issues-percentage-and-header-justify/24472) ---
**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:** [August 7, 2020, 2:55pm UTC](https://forum.inductiveautomation.com/t/perspective-table-numberformat-percentage-multiply-by-100/37492/3 "2020-08-07T14:55:28Z")
Closed on August 7, 2020, 2:55pm UTC