Skip to main content

#Owes SteveMo a Beer0 diskutieren mit

*** SPOILER ALERT *** Darth Vader is Luke's father, and You owe me a beer.

The use case is this....

We can sell up to 59 types of services/products to our customers.

There is a custom object with a checklist for these 59 items (a picklist for each item) where each one states, whether we are working, have secured, or the status is unknown.  Is there a way to count these 59 fields which all have the same global value set, and see the result on the same record, of how many are working, how many are secured, and how many are unknown?  

 

I know I can pull reports from the opportunities to see how many we are working on and have secured, but it is important for the client to see out of the 59 items possible, how many they have spoken to the client about. 

 

It's been a long day and I just can't think of a way right now!

 

@Steve Molis

If you can come up with a formula for this, I'll owe you a beer!

12 Antworten
  1. 22. Juni 2021, 19:49

    Crap!  

     

    CASE([Object].Picklist_A , "Working",1,0) +

    CASE([Object].Picklist_B , "Working",1,0) +

    CASE([Object].Picklist_C , "Working",1,0) +

    CASE([Object].Picklist_D , "Working",1,0) +

    CASE([Object].Picklist_E , "Working",1,0)

Hi!  

I need assistance with a formula.  I am trying to create one where IF date field contains 2015 AND status is PICKVAL "Actual", THEN show amount field.  

 

This is what I have and I'm getting an error.

 

(IF(CONTAINS( Booking_Date__c , "2015"))

and

IF(ISPICKVAL(Status__c , "Actual") ),  Booking_Amount__c , 0)

 

The below worked for displaying the amount based on Status.

 

IF(ISPICKVAL(Status__c , "Actual") , Booking_Amount__c , 0)

 

Thank you in advance for your help!!

2 Kommentare
Trying to build a report formula field for on an Opportunity report and I am struggling. I built a Hit Ratio formula: 'WON:SUM / RowCount' which is great. Not I am trying to apply the same hit ratio logic but this time for $$ rather that record count. Cannot figure out how to say divide 'WON: Amount:SUM / ALL: Amount:SUM'. I feel like it should be easy, but it is eluding me. @Steve Molis any idea how? Tried an IF function but not clear how I would say IF Won then return Amount. Thanks!
10 Kommentare