0

NL Sum with Link Filter

Hi

I'm trying to create a SUM of a quantity field in Microsoft CRM SalesOrderDetail table.

I want to SUM Quantity based on a field value present in the associated Product.

The formula I have is:

=NL("Sum","FilteredSalesOrderDetail","quantity","createdon",NP("DateFilter",G$10,G$9),"Link=","FilteredProduct","productid","=productid","Filters=",$C$6:$D$6)

The DateFilter element is working fine, the SUM result changes as the dates change. The Link has no effect, at all! I get the same SUM result with or without the Link.

I've tested my connections using the Table Builder so ProductID is the correct link field. I've used the same filter criteria for the Table Builder and it filters the results correctly. I've even cut'n'pasted from the Table Builder into my normal formula to ensure no typos...still nothing.

I'm in danger of head-scratching induced baldness...anyone able to spot my error or help troubleshoot?

Ta

Dave

1 comment

Please sign in to leave a comment.