7 Replies Latest reply: Dec 13, 2016 5:19 PM by Sunny Talwar RSS

    List Box conditioning

    Jim King

      Can someone explain how to condition a list box from showing amounts that are zero or null.

      I coded the following under the General-->Field --> Expression

       

      =if(aggr(sum({<IDPAGR={'PART','MECH','CAFE','OCSE','COOL'},NOAGRP-={'INTR'}>}Amount)+

               sum({<IDPAGR={'EQUP'},OrderType-={'TI'},NOAGRP-={'INTR'}>}Amount)+

               sum({<IDPAGR={'LABO','INST'},OrderType-={'SR'},NOAGRP-={'INTR'}>}Amount),NANAME)<=0,0,

       

       

             NANAME&' '&sum({<IDPAGR={'PART','MECH','CAFE','OCSE','COOL'},NOAGRP-={'INTR'}>}Amount)+

               sum({<IDPAGR={'EQUP'},OrderType-={'TI'},NOAGRP-={'INTR'}>}Amount)+

               sum({<IDPAGR={'LABO','INST'},OrderType-={'SR'},NOAGRP-={'INTR'}>}Amount))

       

      I would like the NANAME(customer) field along with the Amount to show if the Amount is not zero or null

       

      Also do i need anything under the expression tab?

       

      My result looks like this

      Capture2.PNG

      Thanks in advance

      Jim