cancel
Showing results for 
Search instead for 
Did you mean: 

Customer Number Format - IDT?

Former Member
0 Kudos

I have 'Net Qty' field in universe from HANA View which return data in this format 1234.5

I want to change the format in IDT so that the o/p is 1,234.50

I want comma separater and 00 after decimal.

I read about Custom format editor but not sure about the exact syntax?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello Vishal,

Right Click on Measure-->Create Display Format/Edit Display Format-->Numeric Tab--> Click on Custom and apply the format as shown in screen shot below.

You need to select options from Digits and Separators Token Category only.

Regards

Niraj

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Vishal,

Double click the object to open the definition --> Got to avanced tab --> Create Display Format--> Numeric--> Custom --> Try using #,##0.00