Hi Tim, it looks like there’s a performance issue with the AND() function.
I created a new document that has sales proposals linked to a table of countries. I want a calculated column in the Countries table that shows how much we won there, by summing up rows in the opportunities table.
If I write the column formula like this all is well:
…but if I write the formula like this (which I think should be functionally equivalent) the performance is killed:
When the formula is written with “&&” I can enter an amount in the opportunities table and the value appears instantly. As soon as I change the formula to use AND() it takes 4 seconds for values to appear after I’ve hit enter.
I’m going to go and remove the AND()'s from my other document and see if that helps.
Thought you might like to know.