ASO dynamic member formula
ASO Dynamic Member formula not resolving in certain retrieval scenarios.
In the first screenshot, the expected amount is displayed in cell H8.
However, in the second screenshot, the amount disappears. The only difference in the 2nd screenshot is that I've inserted a new column for 'Budget' scenario. However, I fail to understand why it impacts the 'Actual' value in cell H8.
For further context, it works OK if I zoom in on 'YearTotal'.
'Yeartotal' data storage is set to 'Store'.
'USD_LYBR' is dynamic member formula: