How to get a field value which is unselected, unique and corresponding with current selections

[uacg0009]

Hi all,

I have data like:

Now I select Year=2015, Snapshot=Current, like:

In this case, how can I get the value of Week, I just want to get the "Week01" value using some functions, but I can't select Week, but the value of the Week is unique I think.

I try to use getfieldselection, it doesn't work.

So do you have any idea to solve that?

Thanks!

Aiolos Zhao

[SergeyMak]

Hi,

Just use Only(Week) if it's one value.

Regards,

Sergey

PFA

[SergeyMak · Accepted solution]

Or if it's several values you can use

=Concat(Week,',') to get the list of values

or MaxString(Week) or MinString(Week)

it depends on your requirements

[uacg0009]

Thx for reply so quickly!

[jagan]

Hi,

Use Concat(Week,',')  to get all possible weeks values.

If you only one possible value then you can try using Only(), MinString() or MaxString().

Regards,

Jagan.

[uacg0009]

Thx for reply so quickly!