September 11, 2017 at 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!
September 11, 2017 at 10:30 am
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
September 14, 2017 at 9:15 am
meichmann - Monday, September 11, 2017 10:15 AMHello 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