Allplan Forum: Concatenated values in a custom legend

lukacsicsa…

22.06.2023 - 06:25 *

Hey everybody!

Is it possible to concatenate values from a column in a custom legend to a total row?
For example:

I would like to have in the "TOTAL" row under the "Description" column the concatinated values of the Descriptions (D1, D2 and D3).

Do you have any idea how to solve my problem?
Thank you in advance.

Csaba

Show solution Hide solution

Marcus

26.06.2023 - 14:24

Hi Csaba, i can't provide a link to one of the recent documents. I think it's not (well) documented.
I just have a link to a german document regarding the old list tool:
https://connect.allplan.com/de/forum/themen.html?tx_mmforum_pi1%5Baction%5D=downloadAttachment&tx_mmforum_pi1%5Battachment%5D=63351&tx_mmforum_pi1%5Bcontroller%5D=Post
Basically you have to use a formula within a separate cell like this:
TOTAL(COLUMN13)
Where COLUMN 13 is the cell-number of the legend as far as i remember.
Hope that helps...

VG
Marcus

lukacsicsa…

28.06.2023 - 10:28

Hi Marcus!

I have tried what you have suggested. It works with numerical values (such as integer "I" or double "F").
Sadly with alphanumerical values (string "A") I get a blank cell.

I have created a legend with two columns as follows (see attached Capture01.png):
In Cell 1 the attribute "Name" (@507@) is listed
In Cell 2 the "Object_name" (@498@) is listed. This cell is used as COLUMN2 in the TOTAL row.
Both Cell 1 ("Name") and Cell 2 ("Object_name") are formatted as "A30" (30 character long string values).
In Cell 3 (in the TOTAL row) I have used the formula: TOTAL(COLUMN2), this cell also is formatted as "A30". It displays an empty cell. (see attached Capture02.png)

Csaba

Adjuntos (2)

Type: image/png

Descargado 48 veces

Size: 31,07 KiB

Type: image/png

Descargado 28 veces

Size: 27,18 KiB

Marcus

28.06.2023 - 11:44

Hi Csaba, you're right. That doesn't work for string values.
Does your objects have an additional attribute aka factor or something like this?
You could use that as an invisible cell and use it to calculate the sum.

VG
Marcus

lukacsicsa…

28.06.2023 - 12:25

Hi Marcus!

Yes, every object has a "factor" value, which is a numerical one.
I don't quite understand the logic behind using an invisible cell for concatenating string values.
Could explain it in more detail?

Judy_Allpl…

28.06.2023 - 22:23 * [Solución]

Hi Lukas,

i don't think it's possible to concatenate value or string inside a legend. As soon as you work on a footer(Total line), you usualy sum all the values.

If it was only one line like on a table of 4 column:

Column1 Column2 Column3 Column4
Value 1 Value 2 Value 3 Value1 / Value2 / Value3

You could concatenate all column in the field of the Column 4 by using a special syntax like:
"" + Column1 + " \ " + Column2 + " \ " + Column3

In this case, you could display all separate value without make any sum by using a text separator.

But in the end of legend (Footer), i don't think there is any possibility.

Bye & Good Use!

Mr Judy GURAVADU
Responsable Technique Préfabrication & Ingénierie
Precast Sales & Support

Allplan France & Allplan Software Engineering

Depuis 2006

Marcus

29.06.2023 - 09:45

Cita de: lukacsicsaba

Hi Marcus!
Yes, every object has a "factor" value, which is a numerical one.

I don't quite understand the logic behind using an invisible cell for concatenating string values.

Could explain it in more detail?

My bad, haven't consequently read through your first post.
I thought you want to sum up all your objects by count.

VG
Marcus

[Pregunta] Concatenated values in a custom legend [Guardado]

Show solution Hide solution

Adjuntos (2)