Difference in same column of numbers with a formula
Mar 19, 2019 2:48 PM(1065 views)
Hi! I am new to jmp and I have a big data set I am working with, and I need to be able to calcuate the difference to help find rainfall for every 15 minutes during the day, the rainful is given in a column that sums it up daily. I have tried doing an if statement, but it seems to be ignoring the second line of code.
12:00 AM .01
12:15 AM .03
12:30 AM .07
1 AM .09
I need my new column to say
It starts with if the time contains 12:00 AM then dailyrain = dailyrain.