HookEmHorns
Programmer
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
""