Hello
Any one help me , why the excel calculation showing #value error when the unit cost is blank.
after the report is generated, if I put cursor and take out in that blank cell , then the error goes away.
Date
Votes
6 comments
-
Jet Reports Historic Posts When you are using filters that can get empty, you need the suffix "@@" to tell NAV it is ok that the filter is empty, otherwise NAV will report an error.
Something like this:NL("Rows";"Customer";"Name";"No.";"@@"&$D7)
HTH
rmw -
Jet Reports Historic Posts Thanks RMW
-
Jet Reports Historic Posts Hello RMV
that @@ for blank cells already there in the function but still that error is coming in the blank cell, could you please have look at the file I attached in the first post. -
Jet Reports Historic Posts F13 =NL("Rows","Item","No.","Product Group Code","@@"&C13,"1 No.",$F$6,"78 Sales (LCY)","<>0")
H13 =NL("First","Item","Unit Cost","No.","@@"&$F13)
I just noticed in some product groups no items are there, only for those rows unit cost is coming zero but still the resultant formulas in the same row this value error is coming.
Please help!!
Thanks and regards -
Jet Reports Historic Posts Hello RMW
I filtered the product posting group without sales to avoid blank items.
I still have only one problem, only in the last record still comes with the value error due to blank product row.
Please help -
Jet Reports Historic Posts Hi,
the last error occurs, because there is no value in cell H167. So the calculation in cellK167 gets an error.
You can use an "IF"-Formular to get around this error…Have you tried that before?
something like
=IF(H167>0;J167-(I167*H167);J167-(I167*0)) or something else directly in cell H167…
regards
jetsetter
Please sign in to leave a comment.