Range Lookup

[Charles Ang]

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:

Capture.PNG (8.25 KiB) Viewed 2074 times

socso:

Capture2.PNG (5.71 KiB) Viewed 2074 times

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,

[Wim Gielis]

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...