Can anyone help me?
I have a table which has item id, moduletype, unit id, price field.
I would like to do calculation like this.
For the same item price is different according to moduletype.
I would like to select price as 'cost price' only when moduletype='0'
and price as 'purchase price' if moduletype='1'
I tried to use case statement but it shows me null if condition doesnot satisfy.
I want to show the cost price and purchase price of one item in one row not in two row . SO, case statement doesn't work at this time (i think).
And also if unit id of the cost price doesn't match with the unit price of purchase prise than i need to convert the unit id of purchse price to unit id of costprice. How can i do that?
Thanks in advance
P