Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
c20088ac
Contributor
Contributor

Eliminate Filter and eliminate null values from field in set analysis

Sum({<Processes = {"=Len(Processes)>0"}, Date=>}Aggr(Max({<Processes = {"=Len(Processes)>0"}, Date=>}TE),Comment, Processes , Date))

 

Hello, I am trying to eliminate the null values from the processes field and eliminate the filtering on the Date field, but this does not work. Could you please help me? 

Labels (3)
2 Replies
BrunPierre
Master
Master

A clarification, do you want to ignore the selection on the date field? If so, then maybe like this

Sum({<Date>}{<Processes={"=Len(Trim(Processes ))=0"}>}Aggr(Max({<Date>}{<Processes={"=Len(Trim(Processes ))=0"}>}TE),Comment, Processes,Date))

vinieme12
Champion III
Champion III

try below

Sum({<Processes -= {""}, Date=>}Aggr(Max({<Processes -= {""}, Date=>}TE),Comment, Processes , Date))

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.