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

    How to use Aggregate function in the Text Box



      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.