0

Can i use an IF statement with an = NL Formula

=@NL("Sum","Value Entry","Item Ledger Entry Quantity","Item No.",$J20,"Posting Date",D$7,"Document No.","PS-INV*")*-1-@NL("Sum","Value Entry","Item Ledger Entry Quantity","Item No.",$J20,"Posting Date",D$7,"Document No.","PS-CR*")-@NL("Sum","Value Entry","Item Ledger Entry Quantity","Item No.",$J20,"Posting Date",D$7,"Document No.","PS-CR*")

That is my current formula - the data source is business central.

The current formula results in a #Div error because the value in cell D20 is 0.

0 comments

Please sign in to leave a comment.