AnsweredAssumed Answered

Excel - SetSelection

Question asked by bencampbell on Feb 21, 2018
Latest reply on Feb 23, 2018 by marcsamu

Hello,

I am trying to use the SetSelection formula in Excel to control multiple layouts (Board v9). The following formula works: =SetSelection("Finance","Year=2018") but when I try and change the entity to Fiscal Year it fails. I thought it might be because Fiscal Year is technically a custom time entity or because there is a space, but I am not able to use Month either. However, I have tried some non-time entities (with spaces) and that does work.

 

Any ideas?

Thanks 

Outcomes