SAP Analytics cloud LOOKUP

[#1]

Hi all!

Our team is trying to create a model with an account member which takes

[RevenueGrowth](This year) / [RevenueGrowth](Last year)

I'm using the formula bar in the modeler to create this and I decided to use the LOOKUP function. The problem is that SAC will not accept any calculations used on the LOOKUP function and we do not wish to create Advanced Formula programs for this model.

Is there any work around this?

The only way I found was to create an account called for Revenue Performance last year, perform a LOOKUP on it,

Then used the result for calculations with other accounts.

Any help would be appreciated.

Fails

LOOKUP([10007] ,[d/Date] =  Current("Year")) + 1

Works

LOOKUP([10007] ,[d/Date] =  Current("Year")) 

[Former Member]

It did 🙂 Thank you very much!

[former_member775357]

Hello Sir,

How did you finished it, i also need that sir? can you please explain it sir.

LOOKUP([OfficerGraduated],[d/FISCALYEAR]=Current("Year"))

Thanks

Logesh