Good day All,
I want to only run this statement:
=NL("Rows=2","Customer Posting Group",,"+Receivables Account","*")
when a field on my options page called "Run Setup" (assume 'Options'$C$7) = "Y"
When any other value in "Run Setup", I don't want this NL statement to run
I have tried a few things but usually results in my other statements on the same line saying that empty filter not allowed.
Please help
Thanks
Tom
Date
Votes
1 comment
-
Jet Reports Historic Posts Official comment Hi All,
Sorry to bother but I think I just solved my own problem.
using =NL("Rows=2",IF(Options!$C$7="Y","Customer Posting Group",{""}),,"+Receivables Account","*") which seems to do the trick.
Regards
Tom
Please sign in to leave a comment.