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

    Block 0 value lines?

    Stephen Hasson




      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.