MyAlteryx
Community
Academy
Help Docs

Welcome to the Alteryx Knowledge Base

Knowledge Base / Designer / GCSE-366 - Report Basic Table Tool formats negative numbers with parenthesis rather than negati...
GCSE-366 - Report Basic Table Tool formats negative numbers with parenthesis rather than negative sign
user

Created/Edited - 5/4/2026 by Ed Phelps | Alteryx

Summary
Report Basic Table Tool formats negative numbers with parenthesis rather than negative sign
Environment

Formatting of negative numbers changed in version 2021.4 from a leading negative sign to parenthesis. Example: -10 now appears as (10).
 

  • Alteryx Designer
    • 2021.4



Cause

GCSE-366 has been created to address this.

Resolution

Add a Select tool before the Table tool to change the data type from numeric to string. When converted to a string, negative values will be represented with a negative sign. 

NOTE:

  • You can use a Formula tool to change the data type if more complex formatting is needed. 

  • ​​​If the Table tool applies conditional row or column rules, ensure they still function as expected with the string data type.

Was this article helpful?