0

field multiplication and subtraction [RESOLVED]

Jet Reports Historic Posts

March 21, 2012 10:18

None

Follow

Hi,
Im starting with Jet Express and get some trouble doing simple task as multiplicating fields.
Exemple of what I want to do:
Total Cost="Sales Line"."Quantity" * "Sales Line"."Unit cost"
Profit="Sales Line".Amount - "Total Cost"

I want to add this 2 fields in my report but can't figure out how to do this calculation with NL functions

thanks for your time

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts March 21, 2012 11:10

  a few more information who might be usefull:
  
  I have this fields in my report design :
  "Sales Header"."No."
  "Sales Header".Nom
  "Sales Header"."Document Type"
  "Sales Line".Amount
  "Sales Line".Quantity
  "Sales Line"."Unit Cost"
  so I want to add two calculated fields in my report design : Total Cost and Profit
  with
  Total Cost = "Sales Line".Quantity * "Sales Line"."Unit Cost"
  Profit = "Sales Line".Amount - "Total Cost"
  
  So i want to press Refresh to automatically calculate this two fields
  I can't find how too create this two calculated fields
  
  Sincerely

• 0
  
  Jet Reports Historic Posts March 21, 2012 13:03

  I don't think there's a easy way to solve this with Jet Express. You can do this by making pivot table from report and then do calculations you want by hand. Problem is when your pivot table expands, then you have to expand your calculations also by hand.
  I'm sure that you can solve this problem with macros if you know to use them.

• 0
  
  Jet Reports Historic Posts March 23, 2012 13:41

  Thanks for your reply.
  Because I could'nt managed to solve this problem I used a macro as you suggested.