Desktop version

Main > Forum > 1C:Enterprise Platform > 1C:Enterprise โ€“ Business applications platform > Precision in Data Composition Schema

Forum

Search UsersRules
Precision in Data Composition Schema
#1
Active user
Points:: 3
Joined:: Sep 16, 2011

I am developing a report using Data Composition Schema. There is a Data Set โ€“ query with Coefficient field. It is calculated as a division of days worked by days planned. So there is a problem with precision: sometimes this column is displayed with 4 digits after decimal point, sometimes with 5, sometimes with 26...
How to make it to have 2 digits after decimal point?

Profile
#2
Active user
Points:: 32
Joined:: Sep 16, 2011

You can use conditional appearance for this field and set the format for digits.

Profile
#3
Just came
Points:: 1
Joined:: Nov 1, 2011

+ #2 And also it can be set a specific format for particular cell in Data Composition Template

Profile
#4
Just came
Points:: 0
Joined:: Mar 12, 2012

+ #3 And also you can use function "Choice" in query or in "Data Composition Schema".
Example:
CHOICE(YouCoefficientField, "Number(16,2)")

Profile
#5
Guest
Points::
Joined::

It's CAST:

Code
CAST(YourCoefficientField, "Number(16,2)")

Profile
#6
Just came
Points:: 0
Joined:: Mar 12, 2012

You are right.
P.S. Help information has incorrect translation from russian to english in 1ะก8.2 (8.2.14.519).

Profile
#7
Guest
Points::
Joined::

Accepted. Thanks.

Profile
Subscribe
Users browsing this topic (guests: 1, registered: 0, hidden: 0)



© 1C LLC. All rights reserved
1C Company respects the privacy of our customers and visitors
to our Web-site.