Current Position:Home > 0QUANTITY - Six decimal places - Rouding to the third decimal place

0QUANTITY - Six decimal places - Rouding to the third decimal place

Update:11-30Source: network consolidation
Advertisement
Hello experts, how are you?
We are facing a problem with decimal places here in the project.
We're using M3 unit of measure and the user required 6 decimal places.
We already changed ANDEC and DECAN fields from T006 table to value 6,
the key figure itself (0QUANTITY), the key figure in the InfoCube and in the input-ready query, but the recorded data is being rounded to the third decimal place.
Can someone help us with it?
Thanks in advance,
Helder Rios

The Best Answer

Advertisement
Hi,
First of all I'd like to thank you for your help guys.
Ashish, I changed the data element RSKYFQUA to 6 decimal places. But when I try to activate the cube, the system is not able to re-create the fact tables.
Do you know if there's a solution for it?
Thanks in advance,
Helder Rios
  • 0QUANTITY - Six decimal places - Rouding to the third decimal place Update:11-30

    Hello experts, how are you? We are facing a problem with decimal places here in the project. We're using M3 unit of measure and the user required 6 decimal places. We already changed ANDEC and DECAN fields from T006 table to value 6, the key figure i

  • Regarding decimal rouding off Update:11-30

    Hi all,             I have a requirement as given below . Can anyone suggest me what should be done to get this solution. "Quantity is a decimal number u2013 The integration team is expecting integer , so lets round it off to the nearest integer if t

  • Decimal Places In VDT Measures Update:10-11

    hi experts, i  have a small problem with decimal places. i'm using the UMC_CPM_STRAT to customize my Measures and VDTs i have created measures using 0QUANTITY and defined 0.00 in the decimal places field. after a while i have changed all the measures

  • Unable to use decimal data in the datasources in the IOP RELEASE 11.1.2.1 Update:11-30

    Hi, I have created a datasource of type Database and given an sql query which is fetching some of the decimal data. But when I am checking preview for the sql query, it is showing integer data (rouding off the decimal value) even though the field typ

  • Bex not showing the Exact decimal values Update:11-30

    Hi, I have a situation here where I created a formula variable Average. I have declared that formula with the help of one replacement path variable. Now My question is when i execute the query, I am seeing the values for that formula varibale but the

  • Grouping and Decimal characters in rtf templates. Update:10-11

    Hi guys and girls, I'm really struggling with a problem here regarding the decimal characters for the prices in my output. I'm using XML Publisher 5.6.3. My goal is to control the grouping and decimal character from my template. The numbers in the XM

  • Error in running a function to convert coordinates in degrees to decimal for EXCEL VBA Update:10-11

    For your information, I have 3 cross-posts regarding this question - and all I can said there is still no firm solution regarding this error. 1) http://stackoverflow.com/questions/27634586/error-in-running-a-function-to-convert-coordinates-in-degrees

  • Using a variable to set decimal place in SAPScript Update:10-11

    Hi Freinds, is it possible to use variable as decimal indicator anf if yes please how. &symbol(E.2)& = two decimal my intension: &symbol(E.2)& = to replace 2 with variable e. g. &QAMV-STELLEN& Thanks, BlackyHi Uma, For Example If t

  • Error while updating decimal places in general settings Update:10-11

    Hii All          I have got an error while updating Decimal places in General Settings Cannot update while another user is connected to the company i have checked, there is no other user logged in, i could add other settings but the problem is only w

  • Can a .pdf created with Livecycle allow a user to enter a % symbol in a numeric or decimal field? Update:10-11

    What I've found so far is that the only way to get the % symbol into a numeric/decimal field at all is to set the "display pattern" to display the % symbol after numbers have been entered into the field. The reason I want the field to be numeric