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

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:

Settings

Common Use Cases

Accepted answers

TonyM

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!

All comments

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.

Alteryx Display Mask example.JPG

TonyM

Alteryx Product Ideas

Thanks!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703