Cannot compare durations. How is this even possible? Is it a bug in Coda?

1

Hi,
I have a table with two columns, both ‘durations’.
In a third column I use a formula with an IF statement to see what duration is longer.
Only the third row is recalculated correctly when I change the duration in the ‘frequency’ column.
How is that even possible?

image
image.png1157×348 22.4 KB

2

Dear @Koen73,

From my mobile:

I am not able to play around with it, but I think you will need to use absoluteValue() for your columns to be able to get values that are comparable and in this way your if statements should become correct.

1 Like
3

Thank you @Jean_Pierre_Traets ! That works!

What is it that absolutevalue() does with a duration?

4

Hi @Koen73,

As the name already suggests it makes from the values an absolute. These values are comparable and therefore your formula will work

1 Like