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.

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    5 years ago

    Yes, perfect, that's how it worked for me. Thank you so much!!!

  • surajlodh_maha's avatar
    surajlodh_maha
    New Member
    2 years ago

    What if I have to multiply two measures?