Skip to Content
0
Former Member
Jan 26, 2007 at 06:38 PM

Formula in an update rule

63 Views

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?