Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My expression will not work and i am getting the error "error in set modifier expression", it is only a simple expression but i cant understand why it wont work.
avg({<NOT ISNULL([table.ApproveDate])>} table.days)
HI try this,
=avg({<Product -= {"$(=isnull(table.ApproveDate))"}>}tables.days)
Regards,
Kaushik Solanki
May be this
Avg({<[table.ApproveDate] = {'*'}>} table.days)
or this
Avg(If(Len(Trim([table.ApproveDate])) > 0, table.days))
This works perfect!
Side question: how can i do the opposite to Avg({<[table.ApproveDate] = {'*'}>} table.days) as in NULL rather than NOT NULL
This becomes a slightly complicated because of the fact that you are looking for NULL. To do this, I would use a uniqueIdentifier field like this
Avg({<UniqueIdentifier = {"=Len(Trim([table.ApproveDate])) = 0">} table.days)
What is UniqueIdentifier ?
Also I am getting the error "Error in set modifier ad hoc element list"
UniqueIdentifier is a placeholder for a field which Uniquely identify each of the row of your table. T
Ok so using:
Avg({<table.IDNumber= {"=Len(Trim([table.ApproveDate])) = 0">} table.days)
I am still getting the error "Error in set modifier ad hoc element list" even though nothing is underlined in red
Solved this without set analysis:
=SUM(if(IsNull(table.ApproveDate), table.days))/COUNT(if(IsNull(table.ApproveDate), table.days))