Filtering text and numbers (NaN) in same module

PhilipVs

Hi there,

 

I have one module(saved view) which is the basis for an export to another system.

This saved view consist of number and text (format), the export in the other system blocks when one of the number returns a NaN.

Therefore we need to exclude these NaN.

 

We thought we found a solution by creating a Line Item List from the module, and creating a boolean based on this.
However the LiS only works for number formatted items, and therefore excludes the text formatted if the filter is applied.

 

Anyone has some other suggestions to approach this?

Thank you in advance!