Mixed number/date formula
I have a formula that doesn't work, i suspect because it refers to both number and date fields and isn't expressed the right way.
It gives results in a time format, always 0:00.
As such, i'm guessing it might be a fairly simple fix, just requiring the formula to be expressed correctly.
This is the formula:
if Filled and 'Close Filled' then
Profit / ('Close Filled' - Filled)
Profit is a number and 'Close Filled' and Filled are dates.