Suggestion: Mask for numeric fields in Results window so that they show commas

[aduplessie]

Hello all,

When looking at the Results window, I often find it a headache to read the numeric results because of the lack of commas. I understand that incorporating commas into the data itself could make for some weird errors; however, would it be possible to toggle an option that displays all numeric fields with proper commas in the Results window alone? What are your thoughts?

For example:

 

[TonyM]

Hi @aduplessie

The commas within the sales field will require converting that data type to a string, and thus, losing all numeric functionality in the workflow.

For display purposes, you can use the ToString function in the formula tool to convert numeric fields to strings and include appropriate commas.

ToString(x, numDec, addThousandsSeparator, decimalSeparator)

Converts a numeric parameter to a string using numDec decimal places. By default, the period is used as the decimal separator.

Optional parameters

addThousandsSeparator: 0 (default) formats the numeric string without a thousands separator; 1 formats with a thousands separator. By default, the thousands separator is a comma unless "," is specified for decimalSeparator, in which case it is a period.

decimalSeparator: "." (default) specifies the period as decimal separator; "," specifies the comma as decimal separator.

Example

ToString(10, 0) returns 10 as a string.

ToString(10.4, 2) returns 10.40 as a string.

ToString(100.4, 2) returns 100.40 as a string.

ToString(1000.4, 2, 1) returns 1,000.40 as a string.

ToString(123456.789, 3, 1, ",") returns 123.456,789 as a string.

ToString(123456.789, 3, 0, ",") returns 123456,789 as a string.

[aduplessie]

Hey Tony!

You are right on with converting between numeric and string types to get the appearance, though it loses the functionally. I am referring toward using a display mask to make numeric fields look like they have the thousands separators while retaining numeric functionality. Would you also find that to be useful? I've mocked up what that would look like in the attached picture.

 

[TonyM · Accepted solution]

Thanks @aduplessie for the idea. I do believe it would be nice to have some added functionality to the results window as well. This post would serve well on the ideas section so other users can vote. Would you mind re-posting?

Alteryx Product Ideas

Thanks!

[aduplessie]

Will do! Thanks for the suggestion

[boomhauer]

Is it possible to describe how to actually add a mask? The photo doesn't show how to do it. Also, the comment marked as a "solution" here isn't actually a solution. Would be great to see the actual solution to this question. Thanks!

[TonyM]

Hi @boomhauer

The topic has been moved to the products ideas page. Please vote for this added functionality there.

https://community.alteryx.com/t5/Alteryx-Product-Ideas/Mask-for-numeric-fields-in-Results-window-for...

Thanks!