Hi All,
I need some suggestions to implement the below requirement for UOM conversion for different units .
I have a transactional data which has Quantity with different UOMs and need to create the other 3 (highlighted) fields in order to get all the quantities in Tone, KG and Ltr as a different KPIs.
![gayatri7_0-1655848877030.png gayatri7_0-1655848877030.png](https://community.qlik.com/t5/image/serverpage/image-id/82317i1ECA091BF9A3EDF3/image-size/medium?v=v2&px=400)
Now, I have another table which has unit of conversion value based on each Material, basically have to multiply the Quantity by Numer/Denom value based on BASE_UOM from below table.
![gayatri7_2-1655849336964.png gayatri7_2-1655849336964.png](https://community.qlik.com/t5/image/serverpage/image-id/82319iC29106DF7F306A81/image-size/medium?v=v2&px=400)
My question is how do I pick the conversion factor (Numer/Denom) from 2nd table based on Material and UOM.
Thanks in advance