0

Create sub-totals for each row

Jet Reports Historic Posts

October 13, 2011 09:23

None

Follow

Hi all,

I've tried to multiply two numeric fields within a NL() formula: =NL("Rows";"Transfer Line";"Quantity (Base)"*"Outstanding Quantity").
But unfortunately this doesn't work. Is there any formula which helps me to create sub-totals for each row? Or do I necessarily need an extra sheet for my calculation?

Thanks for your help.

Best regards,

mm

• Facebook
• Twitter
• LinkedIn

2 comments

• 
  Jet Reports Historic Posts October 13, 2011 15:51 Official comment

  Hi Mm,
  
  Are you trying to actually replicate the multiplication of these 2 fields or do you just want the sum of the multiplication of these 2 fields? I think replication like you have it would not be a good choice because replication eliminates duplicates (so if the multiplication produced the number 32 twice, it would only appear once in the list). I'm guessing you might want something like this:
  
  =NL("Sum";"Transfer Line";"=NF(;""Quantity (Base)"")*NF(;""Outstanding Quantity"")")
  This would multiple the Quantity field by the outstanding quantity field for each record and sum the results. Alternately, if you actually wanted to see the results, you could replicate the table and then get both NF functions in separate cells and multiply them together and then sum the results like this:
  
  B3:
  =NL("Rows";"Transfer Line")C3:
  =NF(B3;"Quantity (Base)")D3:
  =NF(B3;"Outstanding Quantity")E3:
  =C3*D3E5:
  =SUM(E3:E4)
  Does this help help?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts October 20, 2011 06:03

  Hi Hughes,
  
  that was exactly the information I needed! Thanks for your help!!!
  
  Regards,
  
  mm