Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remaining text does not appear to be part of formula
Message
General information
Forum:
Visual FoxPro
Category:
Crystal Reports
Title:
Remaining text does not appear to be part of formula
Miscellaneous
Thread ID:
00995477
Message ID:
00995477
Views:
107
I have a Crystal Reports formula that is a Basic formula that came from the Crystal Reports knowledgebase, but whenever I try to save it I get the error "The remaining text does not appear to be part of the formula."

Why do I get this error? Do I need to do something different within the Crystal Formula because this is Basic syntax? Something missing here? Here's my code. Thanks for a clue. I really appreciate your help.
Dim decInput as number
Dim decimalFraction as number
Dim numerator as number
Dim denominator as number
Dim wholeNumber as number
Dim testNum as number

testNum={@flat_size_l}
wholeNumber=int(testNum)
decInput=round(testNum-wholeNumber,4)
numerator=1
denominator=1
decimalFraction=numerator/denominator

do While(decimalFraction<>decInput)
If(decimalFraction<decInput) Then
numerator = numerator + 1
Else
denominator=denominator+1
numerator=truncate(decInput*denominator)
End If
decimalFraction=numerator/denominator
loop

formula = ToText(wholeNumber,0,"")+"-"+ToText(numerator,0,"")+"/"+ToText(denominator,0,"")
Steve Kramer
Kramer & Kramer Design
"Home of Go Cartoons"
Web Site: www.stephenkramer.com
Would you believe Far Side Lite?
More than 270 original cartoons.
Reply
Map
View

Click here to load this message in the networking platform