You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OTBI Analysis to get a value from the latest project budget version

I have created an OTBI analysis that shows values from the
original budget version , but I want to compare it with the same values
of the latest budget version, but when I use the function of LAST I get
the error

Invalid Alias Format : Table_name.Column_name required. OK (Ignore Error)

my query is

CASE
WHEN "Project Budget Version"."Budget Key" = last("Project Budget
Version"."Budget Key") THEN (ifnull ( cast( "- Budget Line Record
Information"."PJO_PLAN_LINES_DFF_APRFT_SCLTN_NT_" as numeric) ,0) ) ELSE
0

what would be the error or the best approach to reach my goal ?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!