Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I have the following expression, and would like to replace the word 'Centre' right at the end with a variable (vGroupBy), which says 'centre')
I can't seem to get this to work though. I assume I am not concatenating correctly or doing something wrong with my syntax?
(Count(if(AssessmentDate >= $(vAssessmentStartDate) AND AssessmentDate <= $(vAssessmentEndDate), Passed)),Centre)
Thanks in advance.
$(vCentre) (if using SET)
or
vCentre (if using a LET)