Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
5 years ago
Solved

Incorrect total when multiplying columns

I've created a table where I show data from two tables. Table 1: Name and price. Table 2: Quantities. So I'm left with a view: Name, quantities, price. I have generated a new column that multi...
  • Migasuke's avatar
    Migasuke
    5 years ago

    Hi Syndicate_Admin ,

    This formula using sumx and related should solve your problem.
    I have 2 tables. One with Price, second with Quantiy.

     


    Take a look and let me know if it helped!

Migasuke's avatar
Migasuke
Memorable Member
5 years ago

Hi Syndicate_Admin ,

This formula using sumx and related should solve your problem.
I have 2 tables. One with Price, second with Quantiy.

 


Take a look and let me know if it helped!

Data-Rainer's avatar
Data-Rainer
Advocate IV
4 years ago

Thanks Migasuke,
you have solved my issue I have spent half day trying to fix and googled myself to death, almost giving up.
My issue was a standard multiplication of Kilometers x emission factor = carbon created,
whereby the results was double the amount it should have been.
Your solution with SUMX & RELATED has fixed it.
LEGEND! Thanks again.