Hello, I am trying to add a Dimension Code to the following NL function, but when I do it disappears and does not pull proper data. Any thoughts?
=NL("Rows","15 G/L Account",,"1 No.",$E$53,"4 Account Type","0","Company=",$D$3)
Thanks,
Bill
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi Bill.
As long as there is something associated with the results then the function should show. When you add your filter, try clicking on the arrow of the filter value to see available options (Set your filter field as the code, then in the filter click the down arrow). You can always browse available values by looking in the browser. Anytime a replicator function has no results then it will show as a blank so its likely either the dimension doesn't exist in the table or its being mis-spelled in some way (why I am recommending exploring the data).
I hope this helps.
Jason T
Please sign in to leave a comment.