Multiplying a field by 10 issue

[Mario3]

Dear Qlikers, 

hope that you can help with this I am multiply a filed by 10 qlik is behaving like the below:

Expression : if(flag=1,[A DG1_Power_Active_P]*10,[A DG1_Power_Active_P]) as [A DG1_Power_Active_P2]

Output sample  :

DG1_Power_Active_P	DG1_Power_Active_P2
39.0667	390,667

However DG1_Power_Active_P2   should provide the value of 390.667 not 390,667 How can I solve this issue.

Appreciate the help 

Thank you, 

Mario

[QFabian · Accepted solution]

Hi @Mario3 , one option is replace that character :

replace(

if(flag=1,[A DG1_Power_Active_P]*10,[A DG1_Power_Active_P]) as [A DG1_Power_Active_P2]

, ',', '.')

[Saravanan_Desingh]

Under Number tab, check how the Decimal Separator has been defined. If it show comma, change it to dot

[PradeepK]

1. Check field tags - it should be $numeric; if not use num(<field>) in load script

2. Check if decimal separator  is set to '.' in default variables 

3. Make sure there are no surprises at front end - Measure formatting options