1 Reply Latest reply: Dec 25, 2014 2:29 AM by Gysbert Wassenaar RSS

    How to use Aggregate function in the Text Box

      Hello,

       

      I am using the following expression in the text box.

       

      =count (  IF ([Primary Item Quantity]  + sum( [Alternate Item Quantity] )  < [Safety Stock Quantity], [Inventory Item]))

       

      My objective is to find count of item  with Primary and Alternate quantity is less than safety stock.

       

      Please note, Alternate item  is a separate table with one to many relationships with Primary Item.

       

      Above expression gives error.

       

      Kindly Advice.

       

      Abubakker.