cancel
Showing results for 
Search instead for 
Did you mean: 

Account with formula, does not show all data. SAP Analytics Cloud

RafaelMachado
Explorer
0 Kudos

I have two accounts, one with a formula (Ajuste_Anual_Feb) and the other not (V_Ajuste_Anual). The "Ajuste_Anual_Feb" formula was created to take the February value of "V_Ajuste_Anual" and distribute it equally to all members, but it is only distributing where there is a value for "V_Ajuste_Anual".
What could be happening? How could I fix it?
I will attach images to make it clearer.

View Entire Topic
N1kh1l
Active Contributor

@RafaelMachado 

In the formula for Ajuste_Anual_Feb change the RESULTLOOKUP()  to LOOKUP() and it should be fine.

 

Please close the thread if its helpful by accepting the answer.

Br.

Nikhil