0

Sales forecast (field1 - field2)

Jet Reports Historic Posts

September 15, 2014 13:49

None

Follow

Hi there,

i need a little help from the experts here.
i have to do a sales report including monthly forecast. The sum-formular for this report isn't the problem. (=NL("Sum";18;"amount (MW)";"Date";T$4))
But what can i do to calculate 2 different fields? I have to sum "line amount" minus "inv. discount amount".


does anybody have a little hint?

Thanks in advance
kjube

jet-essentials
NAV 2k9

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts September 15, 2014 22:38

  You should be able to do something like
  =NL("Sum";18;"line amount";"Date";T$4)-NL("Sum";18;"inv. discount amount";"Date";T$4)Just put the Excel calculation in the with the NL(Sum) functions

• 0
  
  Jet Reports Historic Posts September 16, 2014 09:39

  Works perfectly
  
  Thanks a lot