• State Suggested Answer
  • Replies 5 replies
  • Answers 1 answer
  • Subscribers 14 subscribers
  • Views 1104 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Data and Records

How to store data in Appian Cloud Database in absolute decimal form?

AtishayJain

I want to save the value for Ownership % field (last column) in the below image, as absolute values, i.e (Number/100)

E.g. If a user inputs 46.00 in the Interface Dashboard, the database would store it as 0.4600

If there any workaround to achieve this?

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Senior Developer

    There are two things when you consider a decimal field in a DDL script used to generate tables like below test table.

    CREATE TABLE `Test` (
      `id` int(11) NOT NULL,
      `ownership` decimal(10,2) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    The 10 indicates the precision which is the maximum allowed integer and decimal digits.The 2 indicates the scale which is 2 decimal places.
    If you want to have only 2 decimal places then update your table with DECIMAL(10,2) like above.
Reply
  • 0
    Certified Senior Developer

    There are two things when you consider a decimal field in a DDL script used to generate tables like below test table.

    CREATE TABLE `Test` (
      `id` int(11) NOT NULL,
      `ownership` decimal(10,2) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    The 10 indicates the precision which is the maximum allowed integer and decimal digits.The 2 indicates the scale which is 2 decimal places.
    If you want to have only 2 decimal places then update your table with DECIMAL(10,2) like above.
Children
No Data

© 2024 Appian. All rights reserved.