3 Replies Latest reply: Apr 3, 2018 1:52 AM by JOHN PETER RSS

    [Count negative Shortage]

    JOHN PETER

      Hi,

       

      I am having  a requirement of finding number of items which have the shortage. sum (inventory) - sum(requirement of current month).

       

      The following is the formula to find the the shortage

      $(Inventory) + $(ParentInventory)-(sum({<ReqDate={"<=$(=MonthEnd(Today()))"}>}req*Usage)) .

       

      I want the count of items which have -ve  values(Shortage).

       

      I thought of using aggr function,but i couldn't get the my result.

       

      Could you please provide me a solution?

       

       

      Thanks,

      John.