Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am using a variable referencing field selections to populate a Match function.
=Match('Count',$(vStoreListMetrics))
vStoreListMetrics is set to =chr(39) & getfieldselections(MetricNames, chr(39) & ',' & chr(39) ) & chr(39)
When I have selected Count from the MetricNames field, I can confirm that vStoreListMetrics evaluates to 'Count'. However the Match function is still returning 0.
Does anyone know why the Match function isn't recognizing the string and the variable evaluation as matching?
Thanks for any help!
Autumn
=match( 'Count',$(=chr(39) & getfieldselections(MetricNames, chr(39) & ',' & chr(39) ) & chr(39)))
Using your expression
=Match('Count',$(=vStoreListMetrics))
I tried this and it worked, and helped me realize I just had to wrap the variable in another dollar sign expansion like you did above... $(=$(vStoreListMetrics))
Thank you!
Very good, I´ve just commented below