I’m working on a use case at the moment that goes through SAP tables and I need to look for red lines which means there are errors. But there is one exception that I need to handle.
If column “Quantity” contains 0, then I need to go over that lane and do not count it as an error.
See screenshot below :
I went through the html code behind these tables, and I have noticed that for every red line found (RedLinesCount variable) , there is 4 times that color code which is ( #fa6a6a ). So I did a count on all the red code colors found and divided it by 4.
Then for all the red lines found check if column Quantity column contains 0, I increment the (RedZeroCount variable). And at last If RedLinesCount>RedZeroCount then I have to send an email stating that errors were found in that table.
Apparently this solution isn’t working out well, it does not take in consideration the RedZeroCount. I would appreciate it if you could help me out with some other solution or even propose to me some adjustment for this existing solution.
Calling @LevKushnir for help.