Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
Just use Only(Week) if it's one value.
Regards,
Sergey
PFA
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
Thx for reply so quickly!
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.
Thx for reply so quickly!