Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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))
try below
Sum({<Processes -= {""}, Date=>}Aggr(Max({<Processes -= {""}, Date=>}TE),Comment, Processes , Date))