Percentage field validation rule to restrict sum of child record values from 0 to 100.

on
Data model:


  • PARENT_OBJECT__c -- PARENT_ROLL_UP_SUM_PERCENT__c
  • CHILD_OBJECT__c -- CHILD_PERCENT__c


Validation Rule in CHILD_OBJECT__c:

IF(ISNEW()
, ((BLANKVALUE( PARENT_OBJECT__r.PARENT_ROLL_UP_SUM_PERCENT__c , 0) + BLANKVALUE(CHILD_PERCENT__c, 0)) > 1.00 )
, ( ((BLANKVALUE( PARENT_OBJECT__r.PARENT_ROLL_UP_SUM_PERCENT__c , 0) - BLANKVALUE(PRIORVALUE(CHILD_PERCENT__c), 0)) + BLANKVALUE(CHILD_PERCENT__c, 0)) > 1.00 )
)
view raw child_validation.txt hosted with ❤ by GitHub

Comments

Post a Comment