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 - SAP ERP Tutorial
From the course: SAP Business One: Reporting and Customization
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
(Locked)
Plan your report with good questions2m 5s
-
(Locked)
Add comments for readability4m 14s
-
(Locked)
Text editors with SQL2m 38s
-
(Locked)
Date and string functions6m 13s
-
(Locked)
Handling NULL values4m 58s
-
(Locked)
Use INNER JOIN for two tables6m 5s
-
(Locked)
Use JOIN for multiple tables5m 47s
-
(Locked)
Group data with GROUP BY5m 27s
-
(Locked)
Use aggregate functions5m 11s
-
(Locked)
Challenge: Sales report with BP info42s
-
(Locked)
Solution: Sales report with BP info5m 3s
-
(Locked)
-
-
-
-
-