Adding calculated fields from different datasets

  • Hello Everyone,
         I have three tables.  Each table has a calculated value, and each table has a different dataset.  What I need to do is add the values from the three tables and get a grand total.

    field a from table 1 (dataset a)
    field b from table 2 (dataset b)
    field c from table 3 (dataset c)

    is there a way to do this?

    Thanks!

  • You will need to provide a lot more for anyone to assist you, well, with any quality replies. 
    Post DDL, sample data, what you have tried so far.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • meichmann - Monday, September 11, 2017 10:15 AM

    Hello Everyone,
         I have three tables.  Each table has a calculated value, and each table has a different dataset.  What I need to do is add the values from the three tables and get a grand total.

    field a from table 1 (dataset a)
    field b from table 2 (dataset b)
    field c from table 3 (dataset c)

    is there a way to do this?

    Thanks!

    Assuming that there aren't any other complicating factors, you can create a "formula" that adds those calculated field values together in the formula, and then place that formula on the report in an "appropriate place", which will depend heavily on the nature of your data, and whether or not you actually want to sum those "calculated values" across all records from each dataset, or just take one value from each dataset.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply