Default value for a Set if formulas not met

[Grantham Good]

We use formulas in a set to default to a legal entity currency, where Legal Entity is one dim and Currency is another. Only issue is when a person Pivots the Legal Entity dim from a selector to a row or column the formula cannot calculate as it is not a single legal entity on display.

Would be good to have a Set instruction that will say- if error then present a default element (eg currency)

I can provide detail iif you want

 

[Lizzie Gatenby]

Hi Grantham,

Thanks for this, I have added it to our feature requests for our engineering team to look at. Thanks again!