0

Circular Reference

I had some formulas on a few fields that worked fine.

When i tried to introduce some qualifying statement, they suddenly fell apart, giving me "Circular reference" errors.

Then, even after i removed the qualifying statement, i still got circular reference errors!

Here's an example where i tried to expand the if qualifier, got cicular reference errors, deleted the expanded statement, then still got circular reference errors.

CRef

In fact, Ninox deleted the field that was supposedly circular - something i find really annoying - and subtituted EA - what does that mean?

Regarding deleting of expressions, why does Ninox do this? I experience it regularly. Why can't it just add the red highight - which is very good - but retain the faulty expressions? Why are they deleted?

You can be working on something for a while, then suddenly Ninox sends it up in smoke.

3replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Rico
    • Rico
    • 3 yrs ago
    • Reported - view

    In my screenshot, my expression isn't deleted, just a field.

    But i've had other cases where Ninox deletes a whole expression.

    Like
    • Rico
    • Rico
    • 3 yrs ago
    • Reported - view

    To be clear, the formula Days Req depends on the results of the formula Movement Req, but Movement Req does not refer to Days Req, so i don't understand how it's a circular reference.

    Like
    • Rico
    • Rico
    • 3 yrs ago
    • Reported - view

    I *think* i have the answer to this for my real formula.

    The issue for the formula proper wasn't a circular reference, but trying to perform divisions with a field that was sometimes empty.

    The formula shown above is just a simplified version of the real formula to illustrate the circular reference error.

    Once i set a condition for the formula not to calculate with a null field, things worked fine.

    Even so, i'm still puzzled by the screenshot above, although i don't really care about that now.

    Like
Like Follow
  • 3 yrs agoLast active
  • 3Replies
  • 1468Views