formatted currency and dmcf issue

Hello,

pls take a look at this post.

https://forum.ninox.com/t/q6yhnnp?r=g9yhag2

I would like to open a new thread about.

Credit goes to Rafael, who was so kind to share a very nice dashboard view, so once again thanky you for that.

I was able to adapt the view to my needs, but there are two issues I would like to ask for help.

1. If you take a look at the field 'Monto gasto' (same with Total gastos at the footer) it is just the number. I would like to format it in currency or at least eg 1.000,00

I checked already that every number field related is formatted and I also tried

format(numberfield, "#,##0.00 €") but no way for me to to accomplish.

2. The field 'Buscqueda categorias' is a multiple dynamic choice field, but it lets me chose only one option.

I tried kind of numbers('Buscqueda categorias'), but without success.

Any idea of how to acomplish this?

Thanks a lot in advanced and have a nive day :-)