expression depending on selection

[#1]

Hi,

I have a dashboard with two expressions and I need to show one expression or the other depending on the selector.

Is it possible?

Thanks,

David

[#2 · Accepted solution]

Of course. Are you making a selection in a field?

If(Only(SelectorField)="Value1", Sum(Expression1), Sum(Expression2))

There are many ways to do it. Using variables is good, because then everything comes from one place.

[#3]

Hello,

There are two selectors, it doesn't depends on the value of the selector, only depends on the selector I use

[Anonymous]

if (getfieldselections ( field name ) , sum ( expression1 ) , sum (expression2 ) )

[#5]

What do you mean by what selector? You mean there are two fields and you're only making a selection on one? Could you give an example?

[#6]

thanks,

Both answers work perfectly

[#7]

And without selecting the field, can I link it with another field in the layout?

ex: I have week and week2, some values are linked with week and others with week2 I need to unify this two fields,

I've tried to do it in the script calling both fields week but when I load a message of circular fields appears (I don't know why),

any idea?

Thanks,

David