How can I format numbers in structure's column into currency format

Question

I want to format a calculated number into a currency format e.g. 100 000 €

I calculate the number

IF type= "Project" :

effort intern * 800 +  effort extern * 1000

This gives me a number like 100000, but I would prefer a format like 100 000 € or €100 000 or any other currency formatting.

Regards,

Thomas

Thomas Fischinger_keyagq · Answer

Thanks, Dionathan for your support. I will try both ways and watch the response of the colleagues.

Still hoping for an all-in-one solution.

All the best,

Thomas

Dionathan Lopes {ALM Works} · Answer

Hello @Thomas Fischinger

In this case, I'm afraid that the CONCAT will not be able to help with the € symbol, but, you could try to use your formula as it was before:

IF type= "Project":

effort_intern * 800 + effort_extern * 1000

You could also change the format from General to Number with 2 decimal places, and then change the Formula Column name to "€". You should see something like:

Please let me know how it goes.

All the best,
Dionathan L

Thomas Fischinger_keyagq · Answer

Hello @Dionathan Lopes {ALM Works}

thanks for your support. This helps. Now, I am able to show numbers in a currency format. However, this is only possible as long as I do not use "sum over sub-items".

Using the "sum over sub-items" as well as "after filtering" would be my preferred solution.

Do you have an idea?

Best Regards,

Thomas