0

Row NL inside an IF function

Jet Reports Historic Posts

April 30, 2014 07:58

None

Follow

Hello everybody:

Sorry if I make any mistake in my message, first time over here… And sorry if the function names are wrong, but I use Jet in Spanish.

I write this post to ask how can I use a row NL inside an IF function:

=IF(condition;NL("rows";……)

I need to use that, and every time I've tryed, it doesn't work properly. I use Sum NLs inside IF functions all the time ( =IF(condition;NL("sum";……) ), but I can not use that when it is a Row NL

Thank you in advance

• Facebook
• Twitter
• LinkedIn

11 comments

• 
  Jet Reports Historic Posts April 30, 2014 11:46 Official comment

  so,
  here as an suggestion for an solution….
  the "trick" is, to have a cell ($D$8) which gives back the fieldname you want to use, dependend on national=yes or national=no.
  Then you use this cell ($d$8) in your NL-function, instead of the filenname….
  
  see attached file..but you have to customize it for your report…
  hope it will work for you, if any questions then ask…
  
  regards

  • solution.xlsx
• 0
  
  Jet Reports Historic Posts April 30, 2014 08:13

  Hi Alain,
  
  greetings from Germany to Spain…! but we can do it in english ;)
  
  IF with NL-rows is a little bit different….
  
  =NL("rows";IF(CONDITION;"item";{""});;"itemno";$D8…..)
  
  Does this help??
  
  regards

• 0
  
  Jet Reports Historic Posts April 30, 2014 08:49

  Hello jetsetter
  
  Thank you for your quick response!
  
  Of course it will help, but i dont understand what you mean with the function you have written, sorry (don't know what colours and "ítem" mean)
  
  For example, could it be like this?
  
  If a company is national, i whant to use the "No." field, to obtain one row for each of the different "No." in the "Account" table, that are "Auxiliar" movements, and that starts by 700XXXXXXX (700*).
  If the company is NOT national, i whant to use the "Code" field in the same way.
  
  =NL("Row";"Account";if(C4="national enterprise";"Nº";"Code");"Movement Type.";"Auxiliar";if(C4="national enterprise";"Nº";"Code");"700*")
  
  NL type
  Source Table
  Wanted field
  Filters
  
  
  Sorry for the reply and tan you so much!
  
  Alain

• 0
  
  Jet Reports Historic Posts April 30, 2014 09:01

  hey,
  no problem, think we can make it.
  
  what is in cell C4? How do you make sure that a company is national or not national? Does the user chose the company, or is the report running through all companies?
  Can you maybe upload an example for your report?
  
  regards

• 0
  
  Jet Reports Historic Posts April 30, 2014 09:27

  In C4 there is another function that is saying if the company is national ("National Company" or "Not National Company")
  
  The reports runs with the user choosing the company, but if the company is national, we must use the field "No.", and if its not national, the "code" field
  
  I dont know how to upload it. Is that posible by this chat? (sorry again, my first time here..)

• 0
  
  Jet Reports Historic Posts April 30, 2014 09:42

  Yes, you can upload here.
  when writing a replay, just scroll down a bit and find "upload attachment"…
  there you go…

• 0
  
  Jet Reports Historic Posts April 30, 2014 10:29

  everithing is in spanish in my report! i have changed the names of fields and tables to be easier to understand. Sorry about that… I hope you understand it

  • JetQuestion_FIN.xlsx
• 0
  
  Jet Reports Historic Posts April 30, 2014 11:08

  hi,
  
  i have a solution that works, will upload it when i'm back from a short break ;)

• 0
  
  Jet Reports Historic Posts April 30, 2014 11:15

  Thank a million!! I look forward it anxiously! :lol:

• 0
  
  Jet Reports Historic Posts April 30, 2014 11:51

  It Works!!!
  
  Thank you so much
  
  I still don't know how can i do to use a row nl with an if, but it Works!

• 0
  
  Jet Reports Historic Posts April 30, 2014 12:05

  thx for your feedback, good to hear, that it works and will help you!
  :D