Calculating off Concatenated table

[#1]

Hi,

I have the need to create calculations off of different fields on a table that has been built by concatenating many tables into one.  I mainly did this because I needed the date fields to be able to be filtered off the entire document.

If you see the below images there are two tables.  The top one is a straight able that shows some calculated values (expressions in the header) and the second image is just a table box.  Can someone help me understand why the Table box shows the correct value but if I put a Sum in front of the value it gives me a number that doesn't make any sense.

Straight Table with Sums

Table Box

[JonnyPoole · Accepted solution]

the numbers in the straight table are inflated 26400 times  ( 660,000/25 = 26400 etc...)

Is that the number of records in the concatenated table ?

Once you have the full concatenated table, it can be helpful to load dimensions with a centralized fact table from that main table to create a star schema (and drop the original concat table).  It can prevent extra counting of records.

Thats only a guess, a look at your QVW would help too.

[#3]

Thank you.  Off of your comment I think I figured it out.  For whatever reason it took the numbers and repopulated them into other fields where it shouldn't have.  I will give your suggestion a try and see if I can't make sense of this.  Thanks for the help.