I added a calculated field in my Products table. The field is populated with a value from a field, let's call it "x", in the Category table. When I assigned a product into a category, that calc field is populated with the expected value. When I change the value of the referenced field "x" in the Category table, the value of the calculated field is not refreshed and retains the old value. Reloading the MDM Server does not seem to help.
The only way I found so far is for me to go to those affected records, change the category to another value and then change it back to the original value. This is not practical and runs counter to why I set-up the calculated field in the first place. Any thoughts and advice on what I should be doing?
Regards,
Simon