How to calculate with numbers in column?

[jisephcirspy]

So, basically I've got a column that looks like this and I want to calculate the average of the column

My draft is this, but it isn't working:

avg({<@time=-{'null'}>} num#(@time'#.##'))

Can you help me?

[martinpohl]

in a set analysis expression you can't work with number settings like num#()

as you can see, the field is left aligned, so the values are text, no numbers.

Edit in script to numbers then you can work with avg

Regards

[fosuzuki]

Hello,

Try this:

=avg({<[@time]=-{'null'}>} num#([@time], '#.##'))

EDIT: I'd recommend you to treat the data previously in the script so that it is ready to use on the front-end. If the data volume is big, the above expression may result in performance issues.

[jisephcirspy]

Thank you for your answer @martinpohl !

How and where can I edit in my script to numbers?

[martinpohl · Accepted solution]

depending on your system

try

num(num#(@time,'#.##'))

or in my case 

replace(@time,'.', ',') 

is working because I have , as decimal seperator

Regards