HOW TO ENTER A NEGATIVE PICKLIST VALUE IN A CASE STATEMENT?

I have a huge formula compiled size 4,628 characters that I am trying to condense.
I think I can do it by stating the negative of a picklist value, but I'm not sure how to do it. Here is my formula:

CASE(text(Deployment_No__c),
"2",STI_Monthly_Cost__c + Cost_for_Discounted_Adults__c + Cost_of_Children__c + Addtl_Lodging_Cost_Total__c + Addtl_Cost_Incidentals__c + STI_Daily_Cost__c-Applied_Credit__c,
"3",STI_Monthly_Cost__c + Cost_for_Discounted_Adults__c + Cost_of_Children__c + Addtl_Lodging_Cost_Total__c + Addtl_Cost_Incidentals__c + STI_Daily_Cost__c-Applied_Credit__c,
0)

I want to rewrite the formula so that it will calculate if the picklist value is NOT "1". That way I can use each of them only once.

Looking forward to your brilliant answers! :)

July 16, 2015
·
Like
0
·
Follow
1

Best Answer chosen by Amanda Jones

Jason Beal
How's this look? If the expression is 1 return 0 otherwise return your calculation.

CASE(text(Deployment_No__c),
"1",0,
STI_Monthly_Cost__c + Cost_for_Discounted_Adults__c + Cost_of_Children__c + Addtl_Lodging_Cost_Total__c + Addtl_Cost_Incidentals__c + STI_Daily_Cost__c-Applied_Credit__c)

July 16, 2015
·
Like
0
·
Dislike
0

This was selected as the best answer

Amanda Jones
Perfect! Compiled size 2,183. You're the man. :)

July 16, 2015
·
Like
0
·
Dislike
0

You need to sign in to do that.

Need an account? Sign Up

Have an account? Sign In

Dismiss

Browse by Topic

Welcome to Support!

Show

sorted by

HOW TO ENTER A NEGATIVE PICKLIST VALUE IN A CASE STATEMENT?

All Answers

You need to sign in to do that.