Precision in Data Composition Schema

The 1C:Enterprise developers forum

#1
People who like this:0Yes/0No
Active user
Rating: 6
Joined: Sep 16, 2011
Company: TLG Integration

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?

 
#2
People who like this:0Yes/0No
Active user
Rating: 3
Joined: Sep 16, 2011
Company: individual

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

 
#3
People who like this:0Yes/0No
Just came
Rating: 0
Joined: Nov 1, 2011
Company:

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

 
#4
People who like this:0Yes/0No
Just came
Rating: 0
Joined: Mar 12, 2012
Company:

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

 
#5
People who like this:0Yes/0No
Timofey Bugaevsky
Guest

Joined:
Company:

It's CAST:

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

 
#6
People who like this:0Yes/0No
Just came
Rating: 0
Joined: Mar 12, 2012
Company:

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

 
#7
People who like this:0Yes/0No
Timofey Bugaevsky
Guest

Joined:
Company:

Accepted. Thanks.

 
Subscribe
Users browsing this topic (guests: 1, registered: 0, hidden: 0)
Be the first to know tips & tricks on business application development!

A confirmation e-mail has been sent to the e-mail address you provided .

Click the link in the e-mail to confirm and activate the subscription.