Getting zeros when using the LOOKUP function

Leonolgun

Hi!

 

I am getting zeros in my data when I am using the LOOKUP function. What are the possible reasons for this? I am sure that I am using the function correct. The function works but the data only shows zeros.

AntonMineev

Hi @Leonolgun

The problem may be that a summation element is chosen as the argument. This is a feature of the function. The solution is in my article: https://community.anaplan.com/t5/How-To/How-to-use-LOOKUP-with-summary-elements/ta-p/137853