Forum Discussion

mikesqu's avatar
mikesqu
Icon for Helper I rankHelper I
5 years ago
Solved

Table values don't add up

Hi all,   As you can see below I have a table of sales giving me the correct column total of 136, but the individual values only add up to 134. The table isn't restricted by size, but I am at a los...
Need Help
  • mikesqu's avatar
    mikesqu
    5 years ago

    Definite an issue with the source table. I will have to review the set up. Thanks for your help anyway guys

  • mikesqu's avatar
    mikesqu
    Icon for Helper I rankHelper I
    5 years ago

    Interesting video, but it is the total figure which is correct and the values which require changing.

    The results are from 2 tables:

    • Lead table 
    • Sale table

    Both of these have a relationship with the following tables:

    • Source table by source name
    • Date table by lead creation date / sale date

     

    As you can see below the 8 in the 3rd row needs to be the correct 10. The top table is using the source table, the second table is using the sources from the sales table. Unfortunately I need the source table used so that the correct number of leads are represented.