I created a scorecard and included a rule that filters out any data with a length less than zero since my rules is meant to see if the data format is correct so I do not care if the data is missing. However when I implement the rule in my scorecard and even try to filter out empty cells there the rows still show up as invalid rows. Does anyone have a solution that will make the rule show invalid data only when the cell is populated by using the filter feature?
Can you verify the rule filter logic once again and ensure that the column data (NULL,'',0x00...) are all included part of the filter logic?
Please share the screenshot here so that we can verify it once.
- Filter logic
- rule logic
- scorecard results