HookEmHorns
Programmer
This is my current formula:
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?
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?