0

Comapny Formula in this one needed - not working

Jet Reports Historic Posts

October 30, 2013 15:30

None

Follow

Hi @ all,

got this one:

="=NL(""Summe"";""Prognosewert"";""Prognosemenge"";""-Nr."";"""&$F20&""";""Datum"";"""&R$4&""";""Projektnr."";""@@""&NF(;""Projektnr.""))"

Need to add Company= and it is not working.

Anybody any ideas?

Thanks,
Oliver

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts October 30, 2013 16:11

  Hi Oliver,
  
  If this is a sort by sum calculated formula, then you need a + or - at the beginning of the formula. Sorting is not applicable within the formula, so you can get rid of the - before your Nr. filter. You should be able to add a company= filter as well.
  
  ="-=NL(""Summe"";""Prognosewert"";""Prognosemenge"";""Nr."";"""&$F20&""";""Datum"";"""&R$4&""";""Projektnr."";""@@""&NF(;""Projektnr."");""Company="";""[Your Company]"")"
  Is this not working for you?
  
  Regards,
  Hughes