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.