cancel
Showing results for 
Search instead for 
Did you mean: 

WDJ Numeric Table Column Format

former_member194198
Active Participant
0 Kudos

Hi All,

I have a WDJ Table with some columns sorted using the standard sort functionality.

One of the columns is Article number which is a numeric column. This sorts fine but the output is formatted as a number with commas.

i.e. 1,000,000 instead of 1000000.

How do I tell the column to remove the commas but keep the numeric sort?

Cheers

Richard

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

MAKE THE variable as integer

former_member194198
Active Participant
0 Kudos

Integer doesn't help as I get commas in the output which I don't want.

String doesn't work as then the sort doesn't work correctly.

Any more ideas?

Former Member
0 Kudos

Hi,

An integer will be having comma.

If your requirement is strict, then always use the integer type for sorting and String type when displaying.

Regards,

Vijay.

0 Kudos

Hi Richard Tucker

Create Simple data type under dictionary as Integer with representation "#############"

Map simple data with you context value attribute type property and see.

the out put will be no commas and sorting will take Integer value.

Regards,

Narayana Kodavati

junwu
Active Contributor
0 Kudos

i think you have to make it as string