Hi,
I use the following formula in my spanish system ( configured correctly in Google Sheets and Chrome where the language used is Spanish )
ROUND(SUM(SELECT(Composicion[e_kcal_composicion], [_THISROW].[id_producto] = [id_producto])) * 100 / [total_peso_producto])
I get the right value using the Spanish notation: 2.066 ( “.” (dot) as a thousand separator )
The problem happens when I use this field in a Chart View. The chart shows it wrongly: 2,066. It uses comma as a thousand separator that is not correct !!!
I have not seen in Chart View any parameter to modify the thousand separator. Any suggestion will be welcome ?
Jordi