How to show values for the same ID in a table on one row

[Anonymous]

Hi all,

CFE, PBL, and VAK are stored as INT values, but these needed to be transformed into a certain format (like this: "99,80"). I achieved this using format and convert.

When I put the INT values in a table; all values are placed on one row for every ID.

However, when I place the transformed CFE, PBL and VAK values in a table; the values are separated over multiple rows for every ID. I need them to be placed on one row, like in the screenshot above. Does anyone have an idea how to fix this?

Thanks!

[_elbpower]

1. where are you doing this formatting on column or measure?
2. Do you want the sum of values and then represent them in the given format?
3. Can you please share the Format string?