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

Status
Not open for further replies.

HookEmHorns

Programmer
Dec 17, 2009
27
US
This is my current formula:

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},0) & '-' & {Data.FacilityName}
ELSE
    ""

In my clients db, they have 3200 stored as the Ledger. When I preview or print my report, its coming out as '3,200'. How can I edit this in my formula to read without the comma's?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top