Default value for a Set if formulas not met

Joined
Feb 27, 2020
Messages
40
Likes
23
Points
8
#1
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