Skip to main content
Topics#CollaborationDenise Schofield 的问题
Denise Schofield (HM Insurance Group) 提问于 #Collaboration
2020年7月1日 04:39

How to create a DTQ Ratio Formula?

We want to include a summary report and graph that will show the total number of quotes vs. quotes that were considered 'Declined to Quote'.  Within our Opportunities we have a stage identified as 'Closed Withdrew' to reflect those quotes that are considered 'Declined to Quote'.  Can someone help me understand how we can build a formula that would take the sum of all quotes vs. those that were declined?
5 个回答
  1. Jonathan Fox (Intellect AI, Intellect Design Arena) Forum Ambassador
    2020年7月1日 13:03
    So your best bet would be to add in a row level formula,

     

    If(ISPICKVAL(Opprtunity.StageName, 'Declined'), True, False) and then group of summarise by this colum 
撰写回答...
0/9000