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

[Thomas Fischinger]

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]

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

[Dionathan Lopes {ALM Works}]

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]

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}]

Hello @Thomas Fischinger 

Dionathan from ALM Works here.

You could try to use CONCAT and see if it helps.

Please find below a formula you could use as a template:

IF type= "Project":

CONCAT ("€ ", effort_intern * 800 + effort_extern * 1000)

or

IF type= "Project":

CONCAT (effort_intern * 800 + effort_extern * 1000, " €")

where effort_intern and effort_extern are your variables.

Please let me know if it helps.

Best Regards,
Dionathan