Newbie Questions

Re: Fancy formatting of row in repeating item table?

RobSil1976 — Mon, 08 Apr 2013 15:18:26 GMT

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.

Re: Fancy formatting of row in repeating item table?

Patrick Halstead — Mon, 08 Apr 2013 03:55:26 GMT

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

Re: Fancy formatting of row in repeating item table?

RobSil1976 — Sun, 07 Apr 2013 17:36:00 GMT

Thanks Hilary! :) Is there a limit to how many variables you can pass into that method? R.

Re: Fancy formatting of row in repeating item table?

Hilary Stoupa — Sun, 07 Apr 2013 16:24:42 GMT

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.

Fancy formatting of row in repeating item table?

RobSil1976 — Sat, 06 Apr 2013 22:55:11 GMT

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