NaN error when concatenating string and currency

M

microb0x

I am getting a return of NaN when trying to concat a string along with
a double(formatted as currency).

Here is my formula:

concat(" USD $", FillinUSDAmount)

I have also tried:

concat(" USD $", string(FillinUSDAmount))

Can anyone shed any light on this? This is my first InfoPath project
so admittedly I am not confident on what I'm doing.

The overall need here is to combine some static text with a currency
value the user imputs. I will be doing this same process at several
points in the form with different fields.
 
S

Swathi

Hi,
Where are you using in concat() method?
Use the below expression in the field which you want as a combination of usd
$ and currency field value as default value.
concat(" USD $ ", field1)
here field1 -> FillinUSDAmount field
 
M

microb0x

I was able to resolve the issue but I'm not sure what I did different.

I think it had to do with where the text field was in the schema when
trying to create the concat() for the default value. I moved the text
field to the same group as the currency value I needed to concat with
and it worked.

As I said, I'm not by any means confident with what I'm doing so I'm
not sure what really fixed the issue.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top