Putting a Filter in Listbox

[Anonymous]

Hi ,

Need Help!

I am trying to put filter in a listbox  for Values > 0 as 'Excess' and Values <0 as 'Short' excluding all values equal to zero present in record.

when trying to do so I am getting some values equal to zero in Short as well as Excess at record level when a selection made for either Short or Excess.

Aggr(if((sum({<  YEAR_R = {$(vPrevYear)},  MONTH_R= {$(vPrevMonth)} >}FINAL_READ)- Sum(INITL_READ))>0,'Excess','Short')),CON_REF)

Above Expression didn't worked for me , So I created another expression shown below by putting three selection in a filter viz. Excess , Short, and Zero , Still I am getting some values equal to zero in 'Short' & 'Excess' at record level.

Aggr(if((sum({<  YEAR_R = {$(vPrevYear)},  MONTH_R= {$(vPrevMonth)} >}FINAL_READ)- Sum(INITL_READ))>0,'Excess',if((sum({<  YEAR_R = {$(vPrevYear)},  MONTH_R= {$(vPrevMonth)} >}FINAL_READ)- Sum(INITL_READ))<0,'Short','Zero')),CON_REF)

Thanks in Advance.

[MarcoWedel]

‌please post sample data.

thanks

regards

Marco