So I added a virtual column to one of my tables, had to change the formula around a few times to make it work, but no matter what I tried I could not get the column to return data that I thought should have been included.
I created a new virtual column again and left the other one in place. I then started writing my formula and updated everything and voila the column contained the data that I thought should be included.
As a test, I then copied the โworkingโ formula from the 2nd virtual column to the 1st virtual column and saved&verified data. The 2nd vcolumn still contained the correct data but the 1st one did not even though the formulas are now identical.
Did the 1st vcolumn somehow get corrupted or what is the deal here?
LinkedIn
Twitter
