From the course: SAP Business One: Reporting and Customization

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Handling NULL values

Handling NULL values - SAP ERP Tutorial

From the course: SAP Business One: Reporting and Customization

Start my 1-month free trial

Handling NULL values

“

- [Instructor] Our report is looking pretty good so far, but notice the release date column is pretty blank for all those planned quantity values. I'd like to have something else here instead of blank, and we can use a case here again. Let's think this out. If I change my report's wear in the future, I want to handle any status so that the release is blank for a planned and cancel. From what we've learned, I can use NP,C. There might be times where I have hundreds of values that might be a status, and that's not going to work. A better solution is to change the column based if it is blank. We call this status null, and I can use that in my code for a case statement. So let's go to the release state up here, and I'm going to make another case statement out of this. So, put this down a little, then I'll go ahead and do case. When the T zero release date is null, or in short if it's empty, then not released, else…

Contents