0

pb of formats in filter formula

Jet Reports Historic Posts

May 17, 2014 00:40

None

Follow

Hello,

I'm trying to make an Union of 2 filters.
The first gives the Cost Center Codes used back from Navision (global Dim 1) in a text Format
the second gives the Cost Center Codes used back from CRM (open data source) in a numeric Format
So when I join both and generates rows, I get for the same cost Center 2 rows because one Comes from CRM in a numeric Format and one from NAV in a text Format.
How can I convert in the filter formula so that I get the results in a numeric Format and not in a text Format?

=nl("Filter";"Sachposten";"Globaler Dimensionscode 1";"mandant=";$R$5;"Datenquelle=";$R$6)

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts May 19, 2014 13:03

  hi,
  in this case i would insert a new column, which calculates the result of the =NL-Formulat with *1.
  
  eg:
  your Formular in cell C4=nl("Filter";"Sachposten";"Globaler Dimensionscode 1";"mandant=";$R$5;"Datenquelle=";$R$6)
  then new in d4 =C4*1
  but you have be sure, that there is no text in c4 ;)
  
  does this work for you?
  
  regards