Substitution formulas in column headers are inconsistent, and break sometimes. cannot figure out why

Emil Amante

Here are some examples:
In the main layout this works fine, but in a drilldown, the substitution formulas break.

Here's another example:

"@Version total" should be "FY26 Forecast (Apr) total", but I have other screens where I have the same setup, but it totally works

If I can at least understand why it breaks, I might be able to configure my screens around it.

Robert Barkaway

Hi Emil, I'd imagine it's because you're drilling by month, your substitution formula is referencing a Fiscal Year selection but you're then drilling down to month on the same tree, does it still error if you drill down by a different entity?