Filtering text and numbers (NaN) in same module
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!
Answers

Could you use the following to populate the filter;
NOT Number Line Item II = Divide(0,0)
Chris
0 
This approach doesnt work!!!0

Divide(0,0) has an output of NaN. What he wanted was to exclude NaN so that all the numbers can pass from one module to another. Not sure what you mean by that. Am I missing something?
0 
I was trying to use the NaN output from Divide(0,0) to filter out the NaN from the number column.
But after testing I have found that it doesnt work as I thought it would.
Chris
0