Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Determine field type before processing

I've inherited a .xls file that i wish to process in Crystal.

But when a "number" filed type is blank, its actually returned as a string type with blanks.

this formula


fails with "the string is non numeric" when the filed contains the blanks

and this formula

if {'Capacity} = "" then tonumber(0.00)



fails with "expecting a number" when the field type is number

Is there anyway i can determine the field type before processing ?

i.e if "fieldtype= number"

then round(tonumber({data.Capacity}),2)

else if "fieldtype=string"

then round(tonumber({data.Capacity}),2)

Former Member
Not what you were looking for? View more on this topic or Ask a question