• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 467
  • Last Modified:

Syntax for adding decimals to a field used in formula??

Experts:

This formula:
"Slope = "& (Sum ({@Slope-DrugCollections}, {'Drug_Collections_'.ClientCode}))

Give me this:
Slope = 0.00

I need this:
Slope = 0.001952381

What syntax do i use to allow for the field to display its many decimals.....?

Thanks
M

0
MIKE
Asked:
MIKE
  • 3
  • 2
  • 2
1 Solution
 
zwseemmCommented:
you would change the decimal places in the formatting of the field. Right click the field and pick format field. Click the number tab and pick customize.
0
 
MIKESoftware Solutions ConsultantAuthor Commented:
I need to use SYNTAX.... the field is inside a formula...
0
 
zwseemmCommented:
are you actually seeing 0.00 in the report? I am not sure how you are seeing 0.00
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
MIKESoftware Solutions ConsultantAuthor Commented:
The data for this formula::

@Slope-DrugCollections}

Looks like this:
0.001952381

BUT, when I place thie formula within a Formula it defaults to displaying like THIS:
0.00

SO....I need to know the SYNTAX to convert it to display multiple decimals...which is its true state.
0
 
James0628Commented:
If you haven't already figured this out, you need to use CStr/ToText so that you can specify the format, as in the solution to your other question (where you were trying to remove the decimals).

"Slope = "& CStr (Sum ({@Slope-DrugCollections}, {'Drug_Collections_'.ClientCode}), 9, "", ".")


 The 9 is the number of decimal places and the "." is the character used to separate the decimals from the rest of the number.

 James
0
 
MIKESoftware Solutions ConsultantAuthor Commented:
Nice work...thanks for the reminder....  : )
0
 
James0628Commented:
No problem.

 James
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now