+ Start a Discussion
Karla Pliego 3Karla 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))

 
RD@SFRD@SF
Hi Karla,
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?
Karla Pliego 3Karla Pliego 3
Buyer agent and buyer side comission are not picklist values they are number fields. The only picklists are the listing syde commission type - which can be a percentage or flat fee.