Good Day,
I'm trying to create a calculated field in a pivot table that will tell me the slope of my data. For the y-values, I'm using my data and for the x-vales, I've tried both a time value and an automated index, since the times are evenly incremental. With both cases, I get a Divide by Zero error.
Has anyone tried this before or does anyone know why I am getting the error or how to fix it?
My data is normalized, as it has been collected automatically, so I'm pretty sure that is not the issue.
Thanks in advance
I'm trying to create a calculated field in a pivot table that will tell me the slope of my data. For the y-values, I'm using my data and for the x-vales, I've tried both a time value and an automated index, since the times are evenly incremental. With both cases, I get a Divide by Zero error.
Has anyone tried this before or does anyone know why I am getting the error or how to fix it?
My data is normalized, as it has been collected automatically, so I'm pretty sure that is not the issue.
Thanks in advance