cancel
Showing results for 
Search instead for 
Did you mean: 

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

S0020706010
Explorer
0 Kudos
593

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?

View Entire Topic
William_Yu
Product and Topic Expert
Product and Topic Expert
0 Kudos

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
Explorer
0 Kudos

Hi William, 

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

Andrew128_0-1731378008722.png

however the figure is not rounding up in the table 

Andrew128_1-1731378048697.png

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