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 ...
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
Community Champion
Community ChampionAnonymous
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
- tamerj1
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