4 Replies Latest reply: Feb 14, 2018 11:18 AM by Stephen Hasson RSS

    Block 0 value lines?

    Stephen Hasson

      abc.JPG

       

       

      In above chart, I want to remove lines where there is no delta in qty.

       

      Detla qty is    =sum(OurReqQty)-sum(Open_Order_Quantity__c)

       

      I have tried this 

      if( sum({1}OurReqQty)-Sum({1}Open_Order_Quantity__c)=0,0,sum(OurReqQty)-Sum(Open_Order_Quantity__c))

      and switched off 'show zero values' in Add-ons, but didn't work. A similiar approach worked on another app recently, but not this time.

       

      Any help appreciated. thanks.