Replace . instead of ,

[Anil_Babu_Samineni]

Hello,

I tried this, Why this is not allowing

Sales

1,34

2,34

avg(Replace(Replace('Sales',','),'.') Sales)

Expected O/P is

Sales

1.34

2.34

[migueldelval]

Hi Anil,

Could you post your answer, to help other people?

Regards

Miguel del Valle

[robert_mika]

Is this front or back end?

Is Sales entry per each row or is this a field name?

[Anil_Babu_Samineni]

Front End only, But i don't want to change use subfield from Scripting.

I am trying to create Pivot table. In that Pivot measure i need to use . instead of ,

[robert_mika]

Could you post your data please?

Screenshot maybe?

[Anil_Babu_Samineni]

PFA.

I mention Expected O/P Also

[adamdavi3s]

Does your data field 'Sales' actually have a , in it or is this just the way the number is being displayed?

Check your decimal separator in the default block of the load script

[MindaugasBacius]

replace(Text(Sales), ',', '.')

But you will get not number but text instead.

[Anil_Babu_Samineni]

Adam, Check the Attachment

[Anil_Babu_Samineni]

I want to calculate Average with That?