Marcus Aurelius
asked on
Syntax for adding decimals to a field used in formula??
Experts:
This formula:
"Slope = "& (Sum ({@Slope-DrugCollections}, {'Drug_Collections_'.Clien tCode}))
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
This formula:
"Slope = "& (Sum ({@Slope-DrugCollections},
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
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.
ASKER
I need to use SYNTAX.... the field is inside a formula...
are you actually seeing 0.00 in the report? I am not sure how you are seeing 0.00
ASKER
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.
@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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Nice work...thanks for the reminder.... : )
No problem.
James
James