InfoPath Dev

Hi there,

I have a repeating table that has Quantity, Description, Unit Price.  I am trying to rearrange the fields in another view so that I can "pretty format" the text.  For example... "New Tires(4)@$4.33" (<descr>(<qty>)@<price>).  Is there an easy way to do this with string addition in a calculated field or do I need to nest numerous concat functions? (or is there an even easier way?)

Thx,

Robin

You shouldn't have to nest your concat:

concat(desc, "(", qty, ")@", price)

I guess the one issue you'll run into is formatting price - it is likely a decimal data type. As such, you may just want to use one expression box (calculated value) for everything up through "@" and another expression box for the actual price.

Yes, but you can just add concats if you need more - e.g. concat(concat(field1, field2, field3, field4), field5, field6, ...)

I even managed to get the dollar amount displaying properly... my final equation is as-below...

concat(my:Description, " @  (", my:Quantity, " x $", round(my:UnitPrice * 100) / 100.00, " each)")

Please note that the divide symbol "/" has a space before after (considers it to be xpath if you don't).

Hope this helps others. :)

R.