How to use Aggregate function in the Text Box

Thu, 25 Dec 2014 04:56:00 GMT

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.

Re: How to use Aggregate function in the Text Box

Gysbert_Wassenaar — Thu, 25 Dec 2014 07:29:51 GMT

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.