Forum Discussion
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 ...
tamerj1
Community Champion
Community ChampionHi 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?
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
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.thats true but what can i do in that case