Combining fields

[Drus]

I need to combine 4 fields from 3 separate tables so that they appear as one result. It works with some but not with others.

Example:
In the below formula, I get my desired result.

{PR_02DirectDepDataEntry.RoutingTransitNumber} + {PR_02DirectDepDataEntry.AcctType}

However, when I add a couple more fields to the mix the result is an error in my formula. Why is this? Here is the formula I am trying that tells me there is an error.

{PR_02DirectDepDataEntry.RoutingTransitNumber} + {PR_02DirectDepDataEntry.AcctType} + {PR6_PayrollDataEntryHeader.DirectDepAmount}




Andrew Hagenbach
OPUS SYSTEMS, INC.
916.503.3173
ahagenbach@opus-sys.com

 

[synapsevampire]

What's the error?

It looks like you're combining strings with numbers, try:

{PR_02DirectDepDataEntry.RoutingTransitNumber} + {PR_02DirectDepDataEntry.AcctType} + totext({PR6_PayrollDataEntryHeader.DirectDepAmount})

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[Drus]

Worked! Thank you so much.

Andrew Hagenbach
OPUS SYSTEMS, INC.
916.503.3173
ahagenbach@opus-sys.com