You need to sign in to do that
Don't have an account?
Karla Pliego 3
Formula not calculating correctliy
I created this formula, to calculate the total amount from a percentage and price fields. It seems pretty straight forward and a similar formula that I build is working fine. This one just spits out a 0, so a calculation is taking place but it is not calculating the total amount as needed.
This is the form
Buyer_Agent_Commision_Total__c
IF( ISPICKVAL( Buyer_Side_Commission_Type__c , 'Percentage %') , Net_Price_After_Seller_Concessions__c * Buyer_Side_Commission__c /100,
IF( ISPICKVAL( Buyer_Side_Commission_Type__c , 'Flat Fee') ,Buyer_Side_Commission__c, 0))
The other formula that works ok is this one. They are the same, the only thing that varies is the fields, what can be wrong with the one above???
LA_Commission_Total__c
IF( ISPICKVAL( Listing_Side_Commission_Type__c , 'Percentage %') , Net_Price_After_Seller_Concessions__c * Listing_Side_Commission__c /100,
IF( ISPICKVAL( Listing_Side_Commission_Type__c , 'Flat Fee') ,Listing_Side_Commission__c, 0))
This is the form
Buyer_Agent_Commision_Total__c
IF( ISPICKVAL( Buyer_Side_Commission_Type__c , 'Percentage %') , Net_Price_After_Seller_Concessions__c * Buyer_Side_Commission__c /100,
IF( ISPICKVAL( Buyer_Side_Commission_Type__c , 'Flat Fee') ,Buyer_Side_Commission__c, 0))
The other formula that works ok is this one. They are the same, the only thing that varies is the fields, what can be wrong with the one above???
LA_Commission_Total__c
IF( ISPICKVAL( Listing_Side_Commission_Type__c , 'Percentage %') , Net_Price_After_Seller_Concessions__c * Listing_Side_Commission__c /100,
IF( ISPICKVAL( Listing_Side_Commission_Type__c , 'Flat Fee') ,Listing_Side_Commission__c, 0))
What is the value of the picklist Buyer_Agent_Commision_Total__c and Buyer_Side_Commission__c for the record you are getting 0 as the result?