You need to sign in to do that
Don't have an account?

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.


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)
.
You can try that formula at first (not sure but that could work).
Hi Alain,
Thanks for the tip. However, when I try it and insert my field name, it says it does not exist???

I double-checked and that is the correct field name. Could it be because the Company field is a formula field itself?
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" ?
Alain