Filtering text and numbers (NaN) in same module

PhilipVs
New Contributor

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!

 

 

5 REPLIES 5
Misbah
Moderator

Re: Filtering text and numbers (NaN) in same module

@PhilipVs 

 

I believe you are converting the text into number format in your source module saved view. Create another line item which will say TEXT(Line item II)

(Edited) - As per Best Practices

Misbah_1-1616763967877.png

 

and then filter on 

Misbah_0-1616763948407.png

 

 

ChrisHeathcote
Community Boss

Re: Filtering text and numbers (NaN) in same module

@Misbah 

Could you use the following to populate the filter;

 

NOT Number Line Item II = Divide(0,0) 

 

Chris 

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA
ChrisHeathcote
Community Boss

Re: Filtering text and numbers (NaN) in same module

This approach doesnt work!!!
Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA
Misbah
Moderator

Re: Filtering text and numbers (NaN) in same module

@ChrisHeathcote 

 

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?

ChrisHeathcote
Community Boss

Re: Filtering text and numbers (NaN) in same module

@Misbah 

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 

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA