Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
please post sample data.
thanks
regards
Marco