I am having issues with a formula in NAV. Please see the attachment. Hopefully someone can help.
Date
Votes
4 comments
-
Jet Reports Historic Posts Hello JGheller,
There is a #VALUE! error reported in Cell W17.
With the Cell W17 selected, click the Debug button on the Jet ribbon.
What happens?
Are you presented with an error message?
If error please post the screenshot of this error as it might lead us to an answer.
Cheers. -
Jet Reports Historic Posts The IF statement in the cell is deliberately checking for 0 and then making it blank if it is. Get rid of the whole IF statement so that you just have the NL("Sum") and you should be fine. If there's nothing to sum it will return 0.
-
Jet Reports Historic Posts Hi Teresa, yes your solution seemed to work, thank you. However, the spreadsheet now has several 0's. The reason for the if statement was to eliminate all the 0's. It made the spreadsheet look too busy and confusing. Is there another way around this?
-
Jet Reports Historic Posts The formula needs to return zero for the maths to work.
However, you can hide them using formatting. Select the cells, right click, and choose format cells. Go to custom and then type this:
0;-0;;@
That will make any zero cells appear blank.
Please sign in to leave a comment.