on 04-05-2016 4:19 AM
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vishal,
Double click the object to open the definition --> Got to avanced tab --> Create Display Format--> Numeric--> Custom --> Try using #,##0.00
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.