I am trying to carry out a calculation on the Pivot Table below.
Field 3 is supposed to be the % of 'completed' and 'total'. So for Row AJC I want it to show 50%, Row EJM 1.13% and so on.
But all I get is the DIV error
The 'completed' value is the 'count' of Risk Profile and the 'Total' is the 'count' of 'Client ID'
I have uploaded screen shots so you can see
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, you may not be aware that you can thank those who have helped you by clicking the small star icon (Next to Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Unless Risk Profile and Client Id are both numbers, you will get an error. The calculated field is actually calculating SUM(Risk profile)/SUM(Client ID)
Everyone who confuses correlation and causation ends up dead.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks