Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Anil,
Could you post your answer, to help other people?
Regards
Miguel del Valle
Is this front or back end?
Is Sales entry per each row or is this a field name?
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 ,
Could you post your data please?
Screenshot maybe?
PFA.
I mention Expected O/P Also
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
replace(Text(Sales), ',', '.')
But you will get not number but text instead.
Adam, Check the Attachment
I want to calculate Average with That?