I have a table, in which the product price changes every year.
When I take the product of unit price and qty without considering year I am getting huge value. As unit price is considered as sum of the unit price across year. Can any one suggest me what can be done to avoid this wrong calculation.
I am attaching to pictures one with the date and the other without date, which will give you better understanding of what I am referring.
Please sign in to leave a comment.