I need to run some calculations off of the results of a DATETIME_DIFF field. The problem is some of the fields are populated with time spans and some have NaN. I am unable to calculate anything with an NaN.
My thought was to first ask if the first date was an empty field, and if so, to simply state 0. If there is a date, it would render the number of days since that date has passed.
If (Delivered = BLANK(), 0, DATETIME_DIFF(TODAY(), Delivered, ‘days’))
So if I needed to calculate how much money I’ve spent on renting an item, I could take the number of days since it was delivered and multiply it by the price. Items which were not rented would not need to add to the cost.
As far as I could tell, this formula should work. Can you please show me where I am going wrong?