Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2006
    Posts
    59

    Arrow Unanswered: Problem with Subreport Calculations

    Hello
    I have a report say 'A' and in that report i have two subreports say 'B' and 'C'
    .I have created a text box in A and i am trying to sum the values of report B and C i tried using this method
    =Report![B]!totalprofit + report![C]!totalexpense
    but it is not giving me correct values it just shows both the values adjacently like 1500+2000 but it should give me only one value i.e 2500

    can anyone help

    regards

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    try expressly converting the values into numbers
    eg
    =csng(Report![b]!totalprofit) + csng(report![C]!totalexpense)

Posting Permissions

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