Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have field in the format of Decimal.
The field Is Customer ID. ex: 123123123123123123
When im extracting him from the Database, he became like this: 1.2223984732987234e+16
What conversion\format should i amply on the field to set him in the right format? thx.
Hi Adi,
Please refer below given solution to this one. Need to check the document override settings. Change the number to integer then it will show properly.
Try like:
Num#(Text([Customer ID])) AS [Customer ID]