0

Custom table filter Balance with dimension

Jet Reports Historic Posts

September 24, 2008 08:36

None

Follow

Hi, I want to get from navision a list of customers where de "Balance" field is "<>0" , but filtering "Balance" with "Global Dimension 1 Code" field, for example filtering it with "=10".

something like: =NL("Rows";"Customer";;"+Nº";"*";"Balance";"<>0") but filtering Balance with "Global Dimension 1 Code"

any suggestion?

thanks

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts September 24, 2008 08:46

  Hi Iurkia,
  
  The Balance field happens to be a flowfield in which a filter on global dimension 1 may be applied.
  
  =NL("Rows";"Customer";;"+No.";"*";"Global dimension 1 filter";"10";"Balance";"<>0")
  Does this do the trick for you?

• 0
  
  Jet Reports Historic Posts September 24, 2008 09:06

  thanks, it works, I just didn't realize of that filter