Need help with Type Conversion

[Lucieann]

LOAN1301.CollCode (Text field)
LOAN1301.Balance (Currency field)
LOAN1301.DirectDebt (Currency field)

What I want to do is if LOAN1301.CollCode is NOT a number, I want to return the LOAN1301.DirectDebt value with a label of "Direct:" in front of it. Other wise I want it to return the value in the balance field with no label.

I am trying to use the following formula:

If NumericText ({LOAN1301.CollCode}) then {LOAN1301.Balance}
else "Direct: " + {LOAN1301.DirectDebt}

The problem with this formula is that I get the message "A string is required here." on the LOAN1301.DirectDebt field. I know that I somehow need to convert the type of data, but I don't quite know how.

 

[bdreed35]

Try this:

If NumericText ({LOAN1301.CollCode}) then
ToText({LOAN1301.Balance})
else
"Direct: " + ToText({LOAN1301.DirectDebt})

Once your balance and direct debt fields are converted to text, you will lose the $ formatting. If you need it, you will need to add it in the string. ( "Direct: $" )

~Brian

 

[Lucieann]

That works great!! Do you know if there is any way to right justify the DirectDebt without moving the "Direct: "label?

 

[bdreed35]

Not without breaking them out into seperate formulas.

Try this:

Change your first formula to this:

If NumericText ({LOAN1301.CollCode}) then
{LOAN1301.Balance}
else
LOAN1301.DirectDebt}

This will just return either field. They are both currency field so you can format them with dollar signs and right align them.

Create this second formula, which is a slight variation of your original formula:

If NumericText ({LOAN1301.CollCode}) then
""
else
"Direct: "

Place this on the report to the left of the first formula. You can now right justify the currency field.




~Brian

 

[Lucieann]

That works great! Thanks for all your help!!!