How to use Aggregate function in the Text Box

[#1]

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.

[Gysbert_Wassenaar]

Perhaps this:

count({<[Inventory Item]={'=only([Primary Item Quantity])+sum([Alternate Item Quantity])<only([Safety Stock Quantity])'}>}[Inventory Item])

If not, please post a document that demonstrates the problem.