Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2006
    Location
    Newbury. UK
    Posts
    3

    Unanswered: NEWBIE HELP: Add formual to CR 8.5 report

    Hi,
    I was wondering if someone could help me out.
    I have a HUGE database. In this database are two fields
    ( {WMSPickRunDetail.QtyToPick} and {Stock.Weight} ). what I need my report to do is muliply {WMSPickRunDetail.QtyToPick} by {Stock.Weight}) and allow me to output the result into a report.
    IE. Qty= 5, stock weight equal 10, output should by 50
    I've tried, but being new to all this, I am have trouble getting it to work.

    Many thanks in advance for your time
    Reguards

  2. #2
    Join Date
    Oct 2005
    Posts
    178
    Quote Originally Posted by smoothas
    Hi,
    I was wondering if someone could help me out.
    I have a HUGE database. In this database are two fields
    ( {WMSPickRunDetail.QtyToPick} and {Stock.Weight} ). what I need my report to do is muliply {WMSPickRunDetail.QtyToPick} by {Stock.Weight}) and allow me to output the result into a report.
    IE. Qty= 5, stock weight equal 10, output should by 50
    I've tried, but being new to all this, I am have trouble getting it to work.

    Many thanks in advance for your time
    Reguards
    Create a formula and call it for example MResult
    and write this function for MResult

    {WMSPickRunDetail.QtyToPick} * {Stock.Weight}

    save it and insert this formula in detail section next to the Multiplicand and multiplier.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •