If Expression Else display N/A

[Fabien]

Hi there,

I am failing to understand why my expression doesn't work here and hope someone can help me.

=If(count(GetFieldSelections([Week Num]))=0,Week(Today())-1,if(count(GetFieldSelections([Week Num]))=1,GetFieldSelections([Week Num]),'-'))

When multiple week numbers are selected [Week Num], it shows the following while i would like to show '-' or N/A (whatever is easier):

[Arthur_Fong · Accepted solution]

Instead of GetFieldSelections, try GetSelectedCount.

[Fabien]

That worked! Thank you @Arthur_Fong 

Final code if it can help anyone:

=If(GetSelectedCount([Week Num])=0,Week(Today())-1,if(GetSelectedCount([Week Num])=1,GetFieldSelections([Week Num]),'Multiple Selection'))