Hi,
We currently have a table with multiple columns. The last column does a calculation based on the input on the two previous columns:
=IF(ABS(SUB(INDEX(Table.Reading,ROW()),INDEX(Table.Reading2,ROW())))>0.5,"No","Yes")
The column had the Display Options: Read-only checked.
We ran into a weird situation where all our tests returned correctly "Yes" or "No" except one or two. The solution was to turn the read-only option off. The ones that were incorrectly showing "No", finally showed "Yes".
Read-only toggled on:
Read-only toggled off:
Is this expected behavior?