function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Karleen MendozaKarleen Mendoza 

Formula field to calculate bucket percentage in reports?

Hi All! however, I'd like to create a percentage between the "Responded" bucket and the grand total. But I have no idea where to get the actual bucket field when creating the formula, it doesn't show up in the Insert buttons.. I have no idea how to use IDE (eclipse) and it won't even download for me.

User-added image

User-added image
Alain CabonAlain Cabon
Hi Karleen,

I have an example close to your problem but there are some differences.

FULL_NAME is for the "Opportunity Owner" for me and for you, it is "Company" Name (just NAME probably).

This is my working formula:

RowCount / PARENTGROUPVAL(RowCount, FULL_NAME, COLUMN_GRAND_SUMMARY)

User-added image


.User-added image


User-added image

You can try that formula at first (not sure but that could work).
Karleen MendozaKarleen Mendoza

Hi Alain,
 

Thanks for the tip. However, when I try it and insert my field name, it says it does not exist???

User-added image

I double-checked and that is the correct field name. Could it be because the Company field is a formula field itself?

Alain CabonAlain Cabon
Hi Karleen,

These parameters are anything but intuitive and I need to do all the combinations myself in order to find the right result.

Verify your "B" field (just above the "Functions" ?

User-added image



User-added image

Alain