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?
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
Thank you @Jean_Pierre_Traets ! That works!
What is it that absolutevalue() does with a duration?
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