When I execute the data action it does not copy the decimals

[S0020706010]

I am executing a data action that ends successfully, but when validating the data from the source version to the destination version, it copies the data but without the decimals.

Origin version data:

Target Version Data(Result shaded yellow):

Already tried the following tests:

1. Validate the format of the number in the style tab of the SAC designer
2. In the data action use the functions (FLOOR, ROUND, TRUNC)
   

   

3. Divide by 1000 to run the decimals

The 3 tests have not been satisfactory.

Has anyone had this problem and know how to solve it?

[MKreitlein]

Hello Sebastian,

I did not have this issue, yet.

The only "problem" I know is, if you create a model key figure as percent, and give only 2 decimals, then you also will not have any decimals, since a percent key figure stores its values differently.

If you want 2 decimals, then you need to use 4 in the model key figure.

Might it be your d/METRICA has a setting "in thousand"?

BR, Martin

[William_Yu1]

Hi abcds,

Few things you can check:

• Measure format and Account format
• Scaling setting for your source table and target table.
• Display data in source table and target table with lowest granularity and all dimensions in row/column axis

Best regards, William

[Andrew128]

Hi William, 

I actually trying to follow the format that you provided, I not able to get the round up figure ? 

however the figure is not rounding up in the table 

* For your information, I'm actually using restricted account to capture Tonnage figure