0

Sum based on the multiplication of two field

Jet Reports Historic Posts

November 03, 2013 10:52

None

Follow

Hi,

i'm trying to get the sum of the multiplication of inventory*sales price?

Item
Code Inventoty
TT1 5
TT2 10
TT3 1

How can i do that in Jet using sum formula?

• Facebook
• Twitter
• LinkedIn

6 comments

• 
  Jet Reports Historic Posts November 11, 2013 16:41 Official comment

  Right, so that would change the formula to something like this:
  
  =NL("Sum","Item","=NF(,""Inventory"")*NL(""Sum"",""Sales Price"",""Sales Price"",""Unit Price"",NF(,""No.""))")
  Does that help?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts November 04, 2013 16:32

  Hi,
  
  If we are talking about NAV, then this is possible with a calculated field. It might look something like this (I'm not sure about the actual fields you want since they might be custom fields):
  
  =NL("Sum","Item","=NF(,""Inventory"")*NF(,""Sales Price"")")
  Does something like that work for you?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts November 11, 2013 08:42

  hi,
  Thanks for your reply.
  t
  he sales price is in other table "Sales price table" witch is linked to the item table by item Code.
  
  Regards;

• 0
  
  Jet Reports Historic Posts November 17, 2013 08:32

  Thanks :)

• 0
  
  Jet Reports Historic Posts January 06, 2014 18:23

  Right, so that would change the formula to something like this:
  
  =NL("Sum","Item","=NF(,""Inventory"")*NL(""Sum"",""Sales Price"",""Sales Price"",""Unit Price"",NF(,""No.""))")
  Does that help?
  
  Regards,
  Hughes

  
  Hi,
  I Need nearly the same result the only difference is that i need Invetory field to be multiplied with Unit Price. Both Fields exist in Item Table. Even though Inventory Field in Item Table exists as a FlowField :
  Sum("Item Ledger Entry".Quantity WHERE (Item No.=FIELD(No.),Global Dimension 1 Code=FIELD(Global Dimension 1 Filter),Global Dimension 2 Code=FIELD(Global Dimension 2 Filter),Location Code=FIELD(Location Filter),Drop Shipment=FIELD(Drop Shipment Filter),Variant Code=FIELD(Variant Filter),Lot No.=FIELD(Lot No. Filter),Serial No.=FIELD(Serial No. Filter)))
  
  This would be my First Request.
  
  The Second would be to extract the Posting Date Field from Value Entry Table. Everything goes back as information on Item Table and these 2 tables have Item No. as a common Field that links them together.
  
  I Hope someone can help me on this one.
  
  The Report that I am Using is the Prebuild Jet Express Report NAV024 - Item Sales and Profit
• 0
  
  Sander Slangen October 01, 2019 11:40

  Is this still possible?