Forum Discussion
Solved
Calculation field in pivot table not working
so, i know this should be really simple, but it is not working for me!! i am beyond frustrated, when i looked at some of the issues on here, i feel really dumb, so i'm really hoping for something qui...
amylou1 Doesn't allow me to download. try sending it to me via a direct message.
amylou1 The number -43927 suggests that the calculation doesn't recognize the approval date as such. The calculated field returns the result of 0 minus April 6, 2020 = -43927. Remember that dates are in fact sequential numbers starting at 1 on January 1, 1900. April 6, 2020 is day number 43927.
Can't tell why the May 6 date isn't seen by Excel without looking at the data. Perhaps the approval dates are in fact texts that merely look like dates.
The attached file contains an example that does what you describe. Though I chose the sum function in the pivot table. Not sure why you chose product and count.