SAP Analytics cloud LOOKUP

[former_member608525]

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_member608525]

Hey afshin, thanks for the quick reply.

I am confused how is this supposed to help me solve the problem.

I want to able to take the current years [10007] results and divide it on the last year results of [10007]. and I want to do this operation on a member in the account dimension.