You are viewing limited content. For full access, please sign in.

Question

Help with concatenate calculation

Forms Version 11

Updated August 27, 2024

asked on August 27, 2024

I have a table that is looking up field values from an external source table. I've added a single line field in that table to concatenate the four field values together as a simpler "display" field. But, I noticed that if my Size field has a value that ends in 0, it's dropped on the concatenate field. See screen shot of my table and my concatenate formula. Any suggestions on how I can get the ending zero to display?

Table.png (32.52 KB)

| Download

Calculation.png (4.72 KB)

| Download

0 0

Answer

APPROVED ANSWER SELECTED ANSWER

replied on August 27, 2024 • Show version history

You probably want the FIXED formula.

Here's Help Documentation about it: https://doc.laserfiche.com/laserfiche.documentation/11/administration/en-us/Default.htm#../Subsystems/Forms/Content/FieldCalculations.htm?Highlight=FIXED

Probably need to wrap this part:

INDEX(ATable.ASize,ROW())

Inside the FIXED formula, something like this:

FIXED(INDEX(ATable.ASize,ROW()), 3)

Tip - Use the "{...} Code" button here in LFAnswers for your formulas rather than a screenshot like you used - to make it easier for other users to tweak your formulas without having to fully re-write them.

2 0

replied on August 27, 2024

That did it! Thanks!

1 0

replied on August 27, 2024

Fantastic! Happy to help.

0 0

Question

Question

Help with concatenate calculation

Answer

Replies

Sign in to reply to this post.