Thanks again for your detailed explanation on this issue.
This should be calculated as part of the loading process, assuming that Col_Val is not updated after loading.
But why "added", simply modify Col_Val
Yes. Col_Val will not be updated after loading but still we will not be able to modify this col_val due to its own reporting requirement (value is different in a real scenario). No bother... we will add a new field in a table to popualte the desired output.
I would really like to say many thanks for your inputs and clarifications.