I input a Calculated Field and do the formula exactly the way the video shows and I end up with a 0 for my calculation. I right click to change the number format and also use the drop down to select "Sum" and it still remains 0. Not a tough formula, simply addition of two fields.
Hey Bill,
Can you please attached your workbook so I can dig into it and see where the issues lies.
It may be a simple thing but I want to see the workbook rather than start guessing.
Thanks,
John
Hmmmm...how would I attach it?
Hi Bill,
For future reference you can attach workbooks to the forum post.
1. Click the 'Attachments' button on the bottom left of where you type your question
2. Select your file
3. Click 'Start Upload'
4. Click 'Submit Question/Reply'
Mynda
Thanks Mynda
Bill
Hey Bill,
You need to change the X in your NEW and RW fields to 1.
This will allow the PT to sum 1s rather than Xs, which it cannot do.
I have done this for you and now the Calc Field Works!
I duplicated the same Calc Field and then right clicked on the values and chose Show Vales As > % of Grand Total to give you the other metric you were after.
I think you are back on track buddy 
Cheers,
John
