Skip to main content
Topics#Data ManagementQuestion de Joshua Luttmer
Joshua Luttmer (Pango Solutions Inc) a posé une question dans #Data Management
5 avr. 2018, 08:02

IF AND CONTAINS Currency Result

So earlier today I got some help on another similar formula however when I tried to add an additonal parameter to the equation it is giving me this error:

 

Here is the Formula I am trying to get to work.  All Objects are Picklists.  I need the formula to return a number as currency.  Help me out, I think I am really close.  I would just forget the CONTAINS but there are 22 picklist options containing Genie or HD-DVR that would need to be replicated for the different Order Types and Offer Types...

 

I could also use some help throwing in a way to tell it does not contain the word LITE in the Receiver picklist for each line as well, if that is possible.

IF(AND(TEXT( Order_Type__c ) = "DTH",TEXT(Offer_Type__c) = "12 Month",CONTAINS("Genie",(TEXT(Receivers__c))),15,
IF(AND(TEXT( Order_Type__c ) = "DTH",TEXT(Offer_Type__c) = "12 Month",CONTAINS("HD-DVR",(TEXT(Receivers__c))),15,
IF(AND(TEXT( Order_Type__c ) = "DTH",TEXT(Offer_Type__c) = "Month-to-Month",CONTAINS("Genie",(TEXT(Receivers__c))),15,
IF(AND(TEXT( Order_Type__c ) = "DTH",TEXT(Offer_Type__c) = "Month-to-Month",CONTAINS("HD-DVR",(TEXT(Receivers__c))),15,
IF(AND(TEXT( Order_Type__c ) = "TMU/BULK",TEXT(Offer_Type__c) = "Special Offer",CONTAINS("Genie", (TEXT(Receivers__c))),10,
IF(AND(TEXT( Order_Type__c ) = "TMU/BULK",TEXT(Offer_Type__c) = "Regular Price",CONTAINS("HD-DVR", (TEXT(Receivers__c))),10,
0))))))))))))

 

 
2 réponses
  1. Sunil Sarilla (M&G Investments)
    5 avr. 2018, 09:40
    Hi Joshua,

     

    I am just fixing your current formula and it will be as below

     

     

    IF(AND(TEXT( Order_Type__c ) = "DTH",TEXT(Offer_Type__c) = "12 Month",CONTAINS("Genie",TEXT(Receivers__c))),15,
    IF(AND(TEXT( Order_Type__c ) = "DTH",TEXT(Offer_Type__c) = "12 Month",CONTAINS("HD-DVR",TEXT(Receivers__c))),15,
    IF(AND(TEXT( Order_Type__c ) = "DTH",TEXT(Offer_Type__c) = "Month-to-Month",CONTAINS("Genie",TEXT(Receivers__c))),15,
    IF(AND(TEXT( Order_Type__c ) = "DTH",TEXT(Offer_Type__c) = "Month-to-Month",CONTAINS("HD-DVR",TEXT(Receivers__c))),15,
    IF(AND(TEXT( Order_Type__c ) = "TMU/BULK",TEXT(Offer_Type__c) = "Special Offer",CONTAINS("Genie", TEXT(Receivers__c))),10,
    IF(AND(TEXT( Order_Type__c ) = "TMU/BULK",TEXT(Offer_Type__c) = "Regular Price",CONTAINS("HD-DVR", TEXT(Receivers__c))),10,
    0))))))

     

     
Rédiger une réponse...
0/9000