Forum Discussion

abrother's avatar
abrother
Frequent Visitor
1 year ago
Solved

Formula bar keeps resetting

Hi all,

 

I'm experiencing a very strange issue where I type in a formula when adding a new column and as soon as I hit Enter the field resets to "Column =" and acts like I never typed anything in. Has anyone experience this before? Any guidance on how to correct this?

  • abrother's avatar
    abrother
    1 year ago

    So somehow deactivating a relationship with another table seems to have resolved this. I don't understand why that would have changed anything, but apparently it has. If anyone ever runs into this I guess just try turning off relationships between your table and other tables before running these formulas.

2 Replies

  • abrother's avatar
    abrother
    Frequent Visitor

    Update on this, I published the report to my workspace and then downloaded it and opened it fresh and was able to get the program to take the formula, but now I'm getting an error where it's referencing some generic "column" in the formula that I didn't type in and that I don't see exists, no idea what's causing this, screenshot below:

     

     

    • abrother's avatar
      abrother
      Frequent Visitor

      So somehow deactivating a relationship with another table seems to have resolved this. I don't understand why that would have changed anything, but apparently it has. If anyone ever runs into this I guess just try turning off relationships between your table and other tables before running these formulas.