0

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)
end

Profit is a number and 'Close Filled' and Filled are dates.

2 replies

null
    • Sean
    • 5 yrs ago
    • Reported - view

    One way would be to use the days() function instead of subtracting one date from another.

    • Rico
    • 5 yrs ago
    • Reported - view

    That's brilliant - nothing like a straighforward solution. And i get to learn into the bargain!

Login to reply

Content aside

  • 5 yrs agoLast active
  • 2Replies
  • 1145Views