Skip to main content
Topics#Reports & DashboardsPregunta de Saranya Kumar
Saranya Kumar (Cognizant Technology Solutions) preguntó en #Reports & Dashboards
15 abr 2021, 13:41

Bucket field error in Summary formula field

Hi,

 

I have question regarding bucket field in a summary formula  field for matrix report . Here is the screenshot of the report .

 

We have bucket field Products with Category values Performace and Shingles, we would like  to get percent of performance/subtotal for record owner.While creating the summary formula getting error bucket field does not exist . "BucketField_49162629:SUM does not exist. Check spelling."

 

Bucket field error in Summary formula field
14 respuestas
  1. Steve Molis (You Owe Me a Beer, Inc.)
    16 abr 2021, 11:56
    Thanks, that helps

     

    Okay so you basically need a Formula like this.  I had to use an Opportunities with Products Report in my Dev org, but the concept is basically the same 

    IF( 
    TOTAL_PRICE:SUM = 0, 0 ,
    TOTAL_PRICE:SUM 
     / 
    PARENTGROUPVAL(TOTAL_PRICE:SUM , FULL_NAME, CLOSE_MONTH)
    )

     

    Thanks, that helps Okay so you basically need a Formula like this.
Escribir una respuesta...
0/9000