Substitution formula not working in block header

So I just want a dynamic trend, where Current Quarter is selected by the user, and then there's trailing 8 quarters. But I want all the quarters to be named accordingly, and pull their fiscal quarter entity member accordingly by description.

All the earlier columns are using fiscal offsets, -3, -6, -9, etc…

But for some reason, no formulas work. Even in current quarter, I'll put @Selection, and it'll just show @Selection.

I do have another screen though where the substitution formula syntax actually works. Is there anything that needs to be enabled in layout or something so that the formulas will work?

Find more posts tagged with

Accepted answers

All comments

Dietmar Jeschkeit

Hello Emil,

If I understand you correctly, you want the quarters to be displayed at the top of the table?
The correct variant is @Entity(Offset=“x”) – where Entity=Quarter and x=-1, -2, etc. – in the block headers.

Take a look at the help section in Board:
https://help.board.com/docs/substitution-formulas

Best regards,
Dietmar

Dietmar Jeschkeit

https://community.board.com/discussion/comment/21560#Comment_21560

I forgot to mention that this only works from version 14.4 onwards.