Hello - I have built a report based on the following key.
=NL("Rows","G/L Entry",,"G/L Account No.","5000..8999","Fund No.",10001,"Global Dimension 1 Code","23964","Global Dimension 3 Code","<>10001L000&<>10001L001","Posting Date","8/31/2013","Company=","CONS_MC","Transaction Type","Actual","Closing Entry",FALSE)
In a period where there are no transactions in the global dimension 1 the key is blank. In these situations the report errors out with an empty filter not allowed.
I tried to bybass this error through an if blank yield 0 statement but that was not returning the original key it was just giving the first value in the key.
How can I build the key/report so that if the key results in no transactions (blank) then the report will not error it will just return zeros.
Thank you
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi,
So when the replicator returns blank, any NF functions referencing it will also return blanks. Your problem is probably happening in an NL(First) or NL(Sum) that is referencing one of those blank NF functions. Basically, if you want to filter on a value that might be blank, you need to prepend "@@" to the filter. So it might look something like this:=NL("Sum","Table","Field","FilterField","@@"&C5)
Notice that I prepended @@ in front of whatever filter value is in C5. So even if C5 is blank this formula would just return a 0 instead of a #VALUE. Does that make sense to you?
Regards,
Hughes -
Jet Reports Historic Posts That worked. Thanks again Hughes!
Please sign in to leave a comment.