Skip to main content
Topics#Data ManagementPregunta de Kelly Javanmardi
Kelly Javanmardi (Fleetsmith) preguntó en #Data Management
9 sept 2019, 22:33

Formula help!

I am really rusty on the Salesforce formula front and could use a little help with a formula structure to incorporate a new variable/filter. Here is an example of our current formula to calculate ARR:

 

License_Count__c * (1- Percent_Off__c)*(IF((TEXT(Plan__c)="monthly"),123, 234))

 

How can I add in a variable that will only run the calculation if "License_Count__c" is greater than 10?
3 respuestas
  1. Arijit Majee (Snowflake Inc)
    9 sept 2019, 22:53
    Hi Kelly,

     

    Try below formula:

    IF(License_Count__c>10,(License_Count__c * (1- Percent_Off__c)*(IF((TEXT(Plan__c)="monthly"),123, 234))),NULL)

    what is the expectation when License_Count__c end up less than or equal to 10. what is the data type of this formula?(assuming as number)

Escribir una respuesta...
0/9000