Can someone please tell me if this statement is possible? I do not want a value error returned if the calculation cell reference is empty.
=IF(F$15<>NULL,("=NL(""Sum"",""Sales Invoice Line"",""Quantity"",""Document No."","""&$F15&""",""No."","""&H$13&""")"),"-")
this statement runs but gives me #Name error. Any way to fix this?
Hello Laura -
The #NAME? error is probably referring to the word NULL.
How about something like this?
=IF($F15<>"",NL("Sum","Sales Invoice Line","Quantity","Document No.",$F15,"No.",H$13),"-")
Thanks! Well good news bad news, I have solved the value and #name errors.. statement is running now - (solved by using "@@"&$F15 ) for empty filter error. But the report is not reading the if statement and using the " - " when the F15 is blank.
Anyways Report is running just with 0 in the " - " place :)
I guess that's good enough for me!