You are viewing limited content. For full access, please sign in.

Question

Question

Read-Only Display Options and Calculations

asked on February 25 Show version history

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? 

0 0

Answer

SELECTED ANSWER
replied on February 26

Try using a rule or JS to set the fields to disable instead of setting the field to Read Only with the checkbox. We ran into a situation a while back like this, and that's what LF told us to try. It was news to me !!

1 0
replied on February 26

Thank you! This worked!

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.