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_member6443 · Accepted solution]

Hi Dan,

My bad , you have stated that you "we do not wish to create Advanced Formula programs for this model." which I did not read clearly.

For a YOY Scenario , Cross Calculations can help or using Difference From .

I hope this helps.

Good luck.

[former_member6443]

Hi ,

Have you tried this

RESTRICT([10007],[d/Time]=Previous("Year",1)and[d/Version]="public.Actual")

RESTRICT([10007],[d/Time]=Current("Year")and[d/Version]="public.Actual")

Regards

[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

[Former Member]

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.