Forum Discussion
Multiply two columns from different table with condition
Hello everyone! I have one column titled ('Unit Cost') from the table named ('Raw Materials') and another column titled ('Rate') from the table ('Exchange Rates'). I would need to mulitply the co...
Thank you for your reply.
I tried the measure but the problem is that I don't want to calculate the sum. I just need to calculate the value of 'Unit Cost' times the "Rate' for each row when the date is the same.
Any developments?