0

Linded Formula with company

Jet Reports Historic Posts

December 09, 2015 15:37

None

Follow

Dear all,

we have a formula like:

=NL("Zeilen=6";"Ressource";"Res.-Gruppennr.";"Gesperrt";$M$2;"Nr.";$M$3;"Res. Betriebskalendercode";$M$5;"Planungsresource";"Nein";"Res.-Gruppennr.";$M$4;"Mandant=";$M$6;"Link=";"Merkmalsleiste";"Nr.";"=Nr.";"Tabelle";"Ressource";"Merkmalscode";"Team";"Ausprägung";"@@"&$D23;"Mandant=";$M$6)

The most important for us is to use another company, therefore mandant= or company=.

Does this work for a linked formula?
Or did we an error.

Thanks,
Oliver

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts December 10, 2015 16:27

  Hello Oliver -
  
  The format of your function appears to be fine (you use the "MANDANT=" in both the main part of the NL function as well as in the LINK= part).
  
  What type of issue are you experiencing?

• 0
  
  Jet Reports Historic Posts December 10, 2015 16:31

  It just give me #WERT
  But when I remove Mandat= the formula works.

• 0
  
  Jet Reports Historic Posts December 10, 2015 21:11

  When you select the cell displaying #WERT and click the DEBUG button (on the Jet ribbon), what additional information is displayed?