In my table, I need information about the amount of products linked to the relevant orders.
I want to divide the GRM quantities by the number 1000 for the calculation in my table to work correctly.
How can I do this using IF in a new column.
If what I want is the "IssuedQuantitiy" column and the "UOMCode" value is GRAM, then the "IssuedQuantitiy" / 1000 will appear in the new column. If "UOMCode" is ST and KGM, then "IssuedQuantitiy" value should be the same.