I have a pivot table that is counting the amount of records from two date data type columns. One column will have a value for the full size of the sample, while the other will either have a value or be blank. I have no issue of counting these columns when dropping them in the "Values" section of the pivot table, but when I try to create a calculated field that divides one column by the other, I receive an error value. Is this due to the data type for both the columns (date)? When I do
COUNT(column)/COUNT(column) I receive 100%, which is incorrect. Any idea of what I'm doing wrong?
Here is an example of the data being divided:
Lead Created Date/Time =
1/1/2017 1:09:00 AM
First Paying Date =
Here is the calculated field (CVR):
='First Paying Date'/'Lead Created Date/Time'
Here is the output: