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

[Former Member]

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.

[N1kh1l]

@Former Member 

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

[Former Member]

@N1kh1l  My hierarchy is YM.

[N1kh1l]

What is the default hierarchy in your date dimension ? Please set the same in your story

[N1kh1l]

@Former Member Once you change it to LOOKUP please make sure the hierarchy for the date dimension is set to YQM. 

Br.

Nikhil

[Former Member]

I changed it to LOOKUP but it gave an error. 

 I removed the Exception Aggregation, and the error no longer occurred. 

 Even so, it is still not possible to see the data in the story.