Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Multiply table1 column 1 from table 2 column 2

I have this table here i want to multiply cost from table 1 into sales from table 2 any help? i build a relationship with table 1 and table 2 according to the date with caardianilty many to many and ...
@Dax
@Daxhelp
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Anonymous 

since the relationship is many to many that means in some dates there is multiple costs. Therefore you have to provide a preference on which price would you like to consider; the max, min or average?

Anonymous's avatar
Anonymous
Not applicable
4 years ago

well i dont want any of that i just want to multiply the cost by the sales no average no min no max just cost * sale and thats it any clue?

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Anonymous 
    I believe you misunderstood my reply. 
    in some instances you might not have a single value of the cost rather it will be multiple cost values in a single day. Then providing a preference is not an option it is a must. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      thats true but what can i do in that case

      • tamerj1's avatar
        tamerj1
        Icon for Community Champion rankCommunity Champion
        4 years ago

        I guess the average value would be a good estimate? I have no idea about the structure and full meaning of your data. This is a decision that has to come from the business responsible. In the following reply I will post a proposed code