Forum Discussion
why are there multiple brackets in this structured ref?
I dont understand why my structured ref has a bracket between the @ and January_2,
and why there are 2 brackets at the end of the reference to the column name, where as multiplier is just one set of brackets [@multiplier] which is what I know about creating row references.
2 Replies
This is the standard structured reference whenever a special character (or space) is used within a column header, such as a period, comma, question mark, underscore, ampersand, etc. The only character that seems to be immune to this behavior is the vertical line or pipe character "|". For example, if you used January|2 as the header, the formula reference would show [@January|2]*[@multiplier].
- great thank you for the clear explanation!.
