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
netopsfadminnetopsfadmin 

Product Pricing Formula

IF(Partner_Pricing_Level__c = "Authorized", (Authorized_Price__c * Quantity),OR(Partner_Pricing_Level__c = "Preferred", (UnitPrice * Quantity)), TotalPrice)

 

What I am trying to do is to say that based on the partner pricing level change the formula for the price.  If there is not a partner pricing level just use the total price value.  I keep getting errors.  Can someone please look at my formula?

shruthishruthi

IF(Partner_Pricing_Level__c == 'Authorized', (Authorized_Price__c * Quantity),

IF(Partner_Pricing_Level__c == 'Preferred', (UnitPrice * Quantity), TotalPrice))

 

The above functions like:

if "Authorized", Authorized_Price__c * Quantity

if "Preferred", UnitPrice * Quantity

else TotalPrice

 

Hope this helps.

 

Regards

Shruthi