turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Find a Community

- Home
- /
- BI
- /
- Enterprise Guide
- /
- Using Computed Columns in Computed Columns

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

02-14-2012 03:42 PM

Probably not the best thread title, but I take real issue with the way the new EG v4.3 handles using a computed column as part of another computation.

Ex:

If I create a computed column

X = 2+4

Then I want to use it for a separate computed column:

Y = X+4

EG automatically fills in for X as {2+4} so it actually looks like

Y = {2+4} + 4

The issue with that is when I make a change to X... Instead of it being 2 + 4 maybe I made a mistake and it needs to be 2+5, so I make the change to X

Now:

X = {2+5}

But this change does NOT propagate to computed column "Y", which still equals {2+4} + 4 instead of {2+5} + 4

The question, I suppose, is how can I make EG treat a computed column as a DYNAMIC variable instead of a static formula that does not retroactively update when used in another computed column? Maybe it's easier to understand if I say I want X = 2+4 to look like this:

Y = X+4 instead of Y = {2+4} +4 how can I accomplish this? I believe in an earlier version treating X as a dynamic variable was STANDARD.