Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 468
  • 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
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

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