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?