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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help with Formula 1

Status
Not open for further replies.

HookEmHorns

Programmer
Dec 17, 2009
27
US
I need some help with my below mentioned formula. Currently the {Data.Ledger} is reading (for example) as 210.00 when my field is 210. If its 215, its reading as 215.00. How can I clip the '.00' off my value? I thought the ToText would help, but its not. Any help is appreciated.

Code:
 IF {?GROUPBY2} = 'Financial Class' THEN
    {Data.FinancialClass}
ELSE IF {?GROUPBY2} = 'Primary Insurance Carrier' THEN
    {Data.InsuranceCarrier}
ELSE IF {?GROUPBY2} = 'Department' THEN
    {Data.Department}
ELSE IF {?GROUPBY2} = 'Doctor' THEN
    {Data.DoctorName}
ELSE IF {?GROUPBY2} = 'Policy Type' THEN
    {Data.InsuranceCarrier}
ELSE IF {?GROUPBY2} = 'Facility' THEN
     ToText({Data.Ledger}) & '-' & {Data.FacilityName}
ELSE
    ""
 
ToText({Data.Ledger},0) should work

-- Jason
"It's Just Ones and Zeros
 
or right click on the field in the report, select Format Field, choose the Number Tab, select a style. "-1123" would work as it has no decimals displayed.
 
Fisheromace...Since the output of the formula is a string, the number formatting options won't be available.

-- Jason
"It's Just Ones and Zeros
 
ahhh, so it is. i read too fast and retained too little before typing.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top