Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I'm trying to create a chart that reflects the activity of a sales group (comprised of Persons A, B, C) but updates to reflect individuals' activities based on the selection. But when I make a selection, the chart does not change and continues to reflect Meetings for A, B, and C. Can someone help? Much appreciated!
count({$<CRM_USER_NAME={'Person A', 'Person B', 'Person C'},TYPE ={'MEETING'}>} %Fact_Key)
Can you post your syntax/expression?
count({$<CRM_USER_NAME*={'LAST1, FIRST1','LAST2, FIRST2'},SLX_TYPE_DESCRIPTION *={'MEETING'}>}%Fact_Key)
Hi
If by syntax error, you mean the wavy red underlining under the *=, you can ignore that, it is a bug in the syntax checker.Your syntax looks OK, but I don't think you need the *= on the second clause of your set expression.
HTH
Jonathan
You're right about the bug! thank you.
Thank you Suraj! but for my needs this doesn't work because I want to display the total count for Person A, B and C when no CRM_USER_NAME is selected.