Replace data with #missing in ASO
I am aware after going through the posts that, in ASO we cant replace data with #missing. For example I am calculating units as below:
units = product shipments/ price.
Lets say I had units already existing, if my product shipments and price are missing then units should be replaced by #MISSING , which happens in BSO but the same wont work in ASO and Oracle has accepted it as a bug.
I need help with the workaround. I can go and do a partial clear of the units, but the end user will not like to do that everytime. Is there a better and user friendly way to do it ?