Support Forum

[Frage] Concatenated values in a custom legend [Gelöst]

lukacsicsaba
lukacsicsa…
22.06.2023 - 06:25 Uhr *

Hey everybody!

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

Element | Description |
------------------------
COLUMN 1 | D1 |
COLUMN 3 | D2 |
COLUMN 2 | D3 |
------------------------
TOTAL | D1; D2; D3 |

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

Lösung anzeigen Lösung verbergen

Judy_AllplanFR
Judy_Allpl…
28.06.2023 - 22:23 Uhr *

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
Marcus
26.06.2023 - 14:24 Uhr

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

lukacsicsaba
lukacsicsa…
28.06.2023 - 10:28 Uhr

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

Anhänge (2)

img
Capture01.png
Typ: image/png
52-mal heruntergeladen
Größe: 31,07 KiB
img
Capture02.png
Typ: image/png
30-mal heruntergeladen
Größe: 27,18 KiB
Marcus
Marcus
28.06.2023 - 11:44 Uhr

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

lukacsicsaba
lukacsicsa…
28.06.2023 - 12:25 Uhr

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_AllplanFR
Judy_Allpl…
28.06.2023 - 22:23 Uhr * [Lösung]

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
Marcus
29.06.2023 - 09:45 Uhr

Zitiert von: 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