Hey, I would like to know if it is possible to concat an integer and a string, but keep the integer in a numeric format? I want to concat multiple objects as value for my pivot table but the numbers should be kept as integers so the separators stay in place -> e.g. "1,000,000€" instead of "1000000€" with "€" being the string that is appended with concat
Help would be highly appreciated!!
You cannot do this with custom expressions. You can , however, choose a currency symbol for the field in Table Metadata.
Actually I would like to concat multiple Columns in a single columns (for a pivot table) -> In my exact Case I would like to display the absolut amount in euro and then concat the absolut amount of deals. Like this for example:
€46,320.00 (#6) -> The amount in Euro should still be displayed with the separators - Is this somehow possible? I couldn't find a way unfortunately -> It is for a pivot table report with just too many rows -> so doing one row for absolut number of deals and one for the amount in euro is not an option.