Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Adding decimal place criteria to existing formula? 1

Status
Not open for further replies.

bobbbb

IS-IT--Management
Nov 26, 2009
1
GB
Hi

I currently have the following formula field in my report and it works fine. What I need to do is to increase the number of decimal places on the output, its currently showing to 2 dp's, I need it to show to 4. Can anyone advise on the best way in which to do this? Any help would be greatly appreciated, Cheers, Bob


If {Documents.Description} = 'FitzIAG Strategic Property Income Exempt UT 1' then "" else ToText({Documents.Units})
 
If {Documents.Description} = 'FitzIAG Strategic Property Income Exempt UT 1' then
"" else
ToText({Documents.Units},4)

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top