Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Decimal Location in Formula Post Reply Post New Topic
Author Message
Dudster
Newbie
Newbie
Avatar

Joined: 23 Mar 2016
Location: Canada
Online Status: Offline
Posts: 3
Quote Dudster Replybullet Topic: Decimal Location in Formula
    Posted: 09 May 2016 at 4:01am
Was looking for advice on how to change the decimal placement in a formula.

Currently the number after the decimal is 3
example: $15.153, I would like it to be, $15.15


This is the formula, any help is appreciated.


ToText(({OEORDD.EXTINVMISC}-{OEORDD.INVDISC}),ToNumber({CSCCD.DECIMALS}))

Cheers
IP IP Logged
Valert16
Groupie
Groupie
Avatar

Joined: 21 Mar 2016
Location: Spain
Online Status: Offline
Posts: 57
Quote Valert16 Replybullet Posted: 09 May 2016 at 7:08am
Are you asking about setting the decimal places in your formula?
The simplest way is through the format editor. Right click your formula --> format field --> click Number tab -->Choose the number of decimals from the list.
You can also click the Customize button and set "Decimals" and "Rounding" values to the same number.
If the number of decimals comes from one table field, you can use the conditional format buttons beside the "Decimals" and "Rounding" values and type this field in the formula editor.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.008 seconds.