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.

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Sean
    • Sean
    • 3 yrs ago
    • Reported - view

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

    Like
    • Rico
    • Rico
    • 3 yrs ago
    • Reported - view

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

    Like
Like Follow
  • 3 yrs agoLast active
  • 2Replies
  • 1138Views