Display message in Dynamic Formula Rules not working
I've spent hours trying to find a solution, but finally I gave up with the hope some of good people in this forum would be able to help me out as it seems like a simple fix.
I have a parent table "Damages" and a child table "Responsible OU (operations unit)". The relationship is One Damage code can have many Responsible OUs. Each team will represent their share of responsibility with a percentage (eg: OU "A" - 40% and OU "B" - 60%). I have a Summary Field in the parent table that adds the total and displays it on the child records so when the users enter a %, they can see what the current total is. My objective is, if a user enters a % and if the total % of the Summary field is more than 100%, then a message is displayed using Dynamic Formula rules on the child table form. I've set a dynamic rule but its not working.
Please kindly direct me towards the right direction.
I have a parent table "Damages" and a child table "Responsible OU (operations unit)". The relationship is One Damage code can have many Responsible OUs. Each team will represent their share of responsibility with a percentage (eg: OU "A" - 40% and OU "B" - 60%). I have a Summary Field in the parent table that adds the total and displays it on the child records so when the users enter a %, they can see what the current total is. My objective is, if a user enters a % and if the total % of the Summary field is more than 100%, then a message is displayed using Dynamic Formula rules on the child table form. I've set a dynamic rule but its not working.
Please kindly direct me towards the right direction.
