Help with Formula 1

[HookEmHorns]

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.

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

 

[jdemmi]

ToText({Data.Ledger},0) should work

-- Jason
"It's Just Ones and Zeros

 

[fisheromacse]

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.

 

[jdemmi]

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

 

[fisheromacse]

ahhh, so it is. i read too fast and retained too little before typing.

 

[HookEmHorns]

Thank you jdemmi, that did the trick!