function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Nevin O'Regan 3Nevin O'Regan 3 

Formula Text Field To Update Based On 3 Currency Fields

I have one currency field which is a manual input "Total_Commission__c". The commission is paid out at 3 stages and is a % of the Total_Commision_c. So what I have done is created 3 custom % fields and 3 custom formula currency fields. Based on the number a user inputs into the % field it calculates the commision for that stage.
Payment no.1 might be 50% of the Total Commission but it also might be 100% of the Total Commission. What I'd like is a field to show if the commision has been paid in full. So If Payment 1 = 50% then the field displays a simple "No". If Payment 1 = 100% then it should show "Yes". However, if Payment 1 = 50% then it should show as "No", but if Payment 1 = 50% and Payment 2 = 50% then the formula field should show as "Yes".

Sorry it's a bit confusing but would anyone have a solution?
Meghna Vijay 7Meghna Vijay 7
Hi Nevin,
  
IF(AND(NOT(ISNULL(Payment1)), Payment1/TotalCommission = 0.5), 'No', 
IF(OR(AND(NOT (ISNULL(Payment1)), Payment1/TotalCommission = 1), 
AND(NOT (ISNULL(Payment1)), Payment1/TotalCommission = 0.5, 
NOT (ISNULL(Payment2)), Payment2/TotalCommission = 0.5)), 'Yes', false);

Hope it helps.
Thanks.