Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Check out our powerful new search update! You can read more here. Please let us know if you have any feedback by creating a topic here.
SOLVED

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

Highlighted
Alteryx Partner

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:

 Example.JPG

Highlighted
Alteryx
Alteryx

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.

Alteryx Partner

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

 

 

 

 

 

 

Highlighted
Alteryx
Alteryx

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!

Highlighted
Alteryx Partner

Will do! Thanks for the suggestion

Highlighted

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!

Highlighted
Alteryx
Alteryx

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!

 

Labels