General

Re: Concatenate total amount of a repeating table

Kharrison — Tue, 07 Jul 2015 18:57:28 GMT

IT WORKED!!!! :) You are awesome!!! Thanks Hilary.

Re: Concatenate total amount of a repeating table

Hilary Stoupa — Tue, 07 Jul 2015 18:50:58 GMT

Whoops. :)

Here's a fixed version.

Re: Concatenate total amount of a repeating table

Kharrison — Tue, 07 Jul 2015 18:15:01 GMT

One last thing... The formula is working fine but I'm now getting 1.25.07/07/15 (two decimals) when there are cents. Any suggestions? Thanks.

Re: Concatenate total amount of a repeating table

Kharrison — Tue, 07 Jul 2015 16:20:07 GMT

Perfect! Perfect! Perfect! Thank you so much!

Re: Concatenate total amount of a repeating table

Kharrison — Tue, 07 Jul 2015 16:06:40 GMT

Thanks Hilary... I'll try and let you know.

Re: Concatenate total amount of a repeating table

Hilary Stoupa — Tue, 07 Jul 2015 15:41:27 GMT

I'm confused as to why you are using a double eval in your formula. It appears the fields in your concat statement in the double eval are not in your repeating group?

At any rate, here's a sample that has a calculated value that should always return two decimals that may help you with this. Save it locally, right click and select design to open in design mode. From there you can preview and type a number w/ or w/out a decimal in the field on the form.

Re: Concatenate total amount of a repeating table

Kharrison — Tue, 07 Jul 2015 15:23:03 GMT

Ok... Thank you.

Re: Concatenate total amount of a repeating table

Hilary Stoupa — Tue, 07 Jul 2015 15:18:10 GMT

I'll see if I can clarify what I was trying to say. Your number is being stored as a number - but when you are formatting the "Amount" field on the form, it is set to include the decimal. That formatting is something separate from the actual value. The formula you are using is only going to return the actual value. So if it were 23.50, you would see 23.5. If you look at the XML in a text editor, you'd see that the amount is actually 23 or 23.5 in the cases where you aren't seeing as many decimal places as you wish.

This could probably be done with some substring formulas - if I get a chance later today, I'll try to put together a sample.

Re: Concatenate total amount of a repeating table

Kharrison — Tue, 07 Jul 2015 15:15:24 GMT

In a nutshell, I'm trying to get 23.0007/07/15. Thanks,

Re: Concatenate total amount of a repeating table

Kharrison — Tue, 07 Jul 2015 15:09:34 GMT

Hi Hilary, Thanks for replying. I've created two separate fields; one for date and the other for the sum of all 'Amount' fields in the repeatable table formatting to include the decimals. The concat works fine, but only works when there is actual cents involved, e.g. 23.52; but when there are not cents, e.g. 23.00, it drops the zeros and round to 23. See below: eval(eval(group1, "concat(/my:myFields/my:wire_total, /my:myFields/my:inv_no_format)"), "..") Wire_total is the sum of all 'Amount' fields in the repeatable table which drops the zeros. inv_no_format is the date field which is fine. Thanks,

Re: Concatenate total amount of a repeating table

Hilary Stoupa — Tue, 07 Jul 2015 15:00:42 GMT

Do you need this in a field? Or could you just use two calculated values on the form, one next to the other? Then you could format one field as a decimal (including keeping the two zeros) and other as a date....

Concatenate total amount of a repeating table

Kharrison — Mon, 06 Jul 2015 17:18:29 GMT

I have a repeating table with an 'Amount' field and I have a 'Total' field to sum all amounts. Separate from these, I have another field that I'm trying to concatenate the total sum from the 'Total' field with another date field on the form. This is how I did that: Date field: concat(substring(pay_date, 6, 2), "/", substring(pay_date, 9, 2), "/", substring(pay_date, 3, 2)) So, I'm wanting to concatenate the date with the total in a separate field. And this is how I'm doing that: concat(total,date) If my total has cents greater than zero, it is fine. But if I don't have cents, it drops the decimal with the zeros. Is this even possible?