Expression Problem

[#1]

Hi,

My need is to return only the field with type number (eliminate the fields that contain string or character)

I wrote this expression.

Avg({<isNum($(Bruttoeinkommen))={-1}>}Bruttoeinkommen) the editor sgow me Expression ofk but there isn#t any returned data

[#2]

the average salary by sector , by experience .

[sunny_talwar]

Did you look at the attachment above?

[#4]

yes it should be like this  , what was your condition : in my case isn't as simpel as that I get average witt Milliard Eur !!! how did resolve the problem to get the data of one day !!!

[#5]

What did you mean by "Created a cycle group with Day"

[sunny_talwar]

I just used Avg(Salary) and it seems to work. Have you tried using just Avg(Salary)

[#7]

Yes I did and it gives me an average with Mio eur