TM1 Forum

Hello, I am trying to lookup a range of criteria from a lookup cube to another cube.

I have build 2 cubes:
1.socso
2.overhead

I need to lookup the salary I key in the overhead cube and get a contribution.

Overhead input view: socso:
I used the following logic formula.
['Socso Employee'] =N:if( (['Salary']<=DB('socso','1','Max')) ,DB('socso','Employee Contribution'),CONTINUE);

However when i key in 20, it return 0.
wondering any part that i missed?

Thanks,

You miss the element '1' in your True part:

DB('socso','Employee Contribution')

Every cube has at least 2 dimensions.

By the way, Trace calculation on a cell is a hady feature...