Here is how my source data is setup:
$Amt Name Biweekly Pay Amt Project biweekly pay period end date $100 John Smith $500 A 12/31/15 $50 John Smith $500 A 12/31/15 $50 John Smith $500 A 12/31/15 $50 John Smith $500 A 12/31/15
I am entering a calculated field formula named "%age funded" = Amount/Biweekly Pay Period Amt
The value field setting; to summarize value field by = sum
My calculated field is returning for %age funded = 0.125;; not 0.50 as it should be, what is wrong??
I can tell that my calculated field formula, is dividing the actual %age funded by the count of $Amt, is there a way to fix this??
Here is an example of the outputted pivot table:
*row label* Name *row label* Project *row label* biweekly pay period end date *value* sum of $Amt *calculated field* %age funded John Smith A 12/31/15 $250 0.125
Any and all help is appreciated
Bookmarks