Skip to main content
Topics#Data ManagementColin Cormac의 질문
Colin Cormac 님이 #Data Management에 질문했습니다
2013년 7월 24일 오전 1:34

Validation Rule for % Field on Custom Object

We have a % field on a custom object. The custom object has a required field "Account". I'm looking to have a validation rule to prevent users from being able to enter records in this custom object for the same related account where the sum of the % field is > 100%.

 

For example, Account "X" has one associated record in the custom object with a % value = 75%. If a user tries to add another record in this object for Account "X" with a % value > 25% they should receive an error.

 

Any help would be greatly appreciated.
답변 9개
  1. Steve Molis (You Owe Me a Beer, Inc.)
    2013년 7월 25일 오후 6:54
    You need to put it on the Parent object just use: Sum_of_Percentage_of_Rev__c >1.00  and you should be ready to Rock'n Roll
답변을 작성하세요...
0/9000