I'm trying to update a characteristic in the update rule with the value of a date field. The problem is that there are many records being read in the update rule, and only one has the value that needs to be overwritten.
My formula is:
IF( User Status = 'I0045', Update Status, ??? )
I need to know what I should put in place of the ???. If the User Status is anything other than I0045, I don't want the rule to overwrite anything. I've tried using SKIP_RECORD(), but then none of the other update rules are engaged for that record either.
I use some key figures doing this same logic, but I have had to use MAXIMUM to get the rules to work. Does anyone know how to set a formula to overwrite or no update based on the value of a field?