hi,
i had an alias as a result of some calculations using the sql editor. i want to use this alias as one of the fields to be used in a calculation using the events editor. however, i only get a 0 result.
For example, in the sql editor, i have this calculation:
[Other table].Field1 + [Other table].Field2 AS [Alias]
my program correctly computes for the value of [Alias].
however, i only get a 0 result if i use the [Alias] in the events editor to calculate like this:
values("field3") = values("Alias") - 5000
how could the program get the correct value of [Alias] if i use it as one of the fields in the events editor?
thanks!