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

[sunny_talwar]

Try this:

Avg(If(IsNum(Bruttoeinkommen), Bruttoeinkommen))

or

Avg({<Bruttoeinkommen = {"=IsNum(Bruttoeinkommen)"}>}, Bruttoeinkommen)

[Colin-Albert]

AVG is a numeric expression so will exclude any non-numeric data.

AVG(Bruttoeinkommen) should work.

[Chanty4u]

may wrks with

Avg(Field)

Count of rows with no nulls?

[Anonymous]

Maybe.

Avg(If(IsNum(Bruttoeinkommen)=-1, Bruttoeinkommen))

or

Avg(If(IBruttoeinkommen='-1', Bruttoeinkommen))

Regards

[#6]

I try All but I still have the same problem :

For the salary average I get illogical result with Avg(): every day I get Information about the salary (I get null also as a value )with different criteria so when I try to find the AVG() it return a biiig biiig amount !!!!!!!

I thought it is problem of AVG but it seems to be another problem ???

some one could help me how should I think to get the AVG()

[sunny_talwar]

Can you share a sample showing the issue?

[#8]

My data is  Like This  but it is very huge . I want to get the average salary : for each criteria:

Day	Salary	Experience	Sector
Apr 07 2016 12:35:49 GMT	47000	3	IT
Apr 07 2016 12:33:31 GMT	90.000	15	Business
Apr 07 2016 12:43:16 GMT	114000	20	Sales
Apr 07 2016 12:42:34 GMT	60000	15	IT
Apr 07 2016 12:43:12 GMT	98.000	10	Business
Apr 07 2016 12:41:55 GMT	45000	5	Sales
Apr 07 2016 12:46:31 GMT	null	6	IT
Apr 07 2016 12:45:52 GMT	75.000	7	Business
Apr 07 2016 12:46:31 GMT	37th	8	Sales
Apr 07 2016 12:48:03 GMT	80000	9	IT
Apr 08 2016 12:49:40 GMT	96000	10	IT
Apr 08 2016 12:49:40 GMT	95000	11	Sales
Apr 08 2016 12:49:40 GMT	165000	12	sales
Apr 08 2016 12:49:40 GMT	90000	13	other

[sunny_talwar]

What is the criteria here? Expected output?

[sunny_talwar]

Created a cycle group with Day, Experience and Sector as dimensions.

When we are on Experience, you would see this:

When on Sector