Skip to main content
I am creating a report that will show the TCV and Weighted TCV (Both are currency values) of opportunities along with their probability %'s for each one. I am summarizing TCV and Weighted TCV to show Sum under Grand Total. For Probability %, I'd like the Grand total to be the Weighted TCV divided by TCV; how would I do this? I've spent all day trying to figure out a way to do this and I've created a formula for what I thought would've worked, but turns out faulty.
7 respuestas
  1. 7 jun 2018, 13:46
    Marc,

     

     Thank you, this has been a little helpful, although it isn't exactly what I was looking for. I created a custom field "Total Probability" because the Summarizations for Probability (%) weren't giving me the exact answers I had wanted. Is there any way I can tweak with Probability (%) to get the results I'm looking for or is AVG going to be my best bet?

     

     Added,  if you can help me with this as well, I'd like to link each grouped row in my report (Booked, Expected, Best Case, etc.) to a different report with similar information. From the Run Report screen, I'd like to be able to click each line to take me to that separate report. How would I do this?

     

    Thank you again!

     

    Nico