Forum

Notifications
Clear all

Decimal curiosity

3 Posts
2 Users
0 Reactions
85 Views
 B M
(@ventanal)
Posts: 2
New Member
Topic starter
 

Hi everyone,

 

I decided to come here for some help, as I am tired of thinking how this is happening...

Have designed a query that converts some data from the tab Combined, with LE info helps, to the final output on tab SAP TXT, than then manually save as txt, and it used for some data transmission that system requires to be in that specific format.

 

My question, is for data on combined tab, there are prices that contains more than 2 decimals on column K, have marked in yellow those ones, I need to obtain the output with only 2, as you can see on SAP TXT tab, however for 2 of 4 my steps are not working... while it does work for 2 instances..

 

Would you know why? only for 1, what shall I do to improve my query and get the output nicer?

I am attaching the excel file, but let me know if I would need to add any snapshot or code here too.

Looks too big, 5MB, so I am just sharing a link to its download, but again, if you prefer I send any snapshot, please let me know

Link: https://fil.email/ND0AT2nm

Many thanks in advance,

Best regards

 
Posted : 24/10/2019 10:48 am
(@mynda)
Posts: 4761
Member Admin
 

Hi and welcome to our forum,

It appears that numbers where the 3rd value after the decimal is a 5 e.g. 207.775 have a zero appended when split by delimiter. It's a bug, but the workaround is to insert a step: Transform tab > Extract > the first 2 characters.

Mynda

 
Posted : 24/10/2019 6:18 pm
 B M
(@ventanal)
Posts: 2
New Member
Topic starter
 

Hey,

 

Sorry for late response, didn0t have the chance to test it, till now.

It just worked! awesome tip!

Many thanks Mynda for your quick and great response!

BR

 
Posted : 26/10/2019 2:43 am
Share: