String Variable In Expression

Tue, 01 Jul 2014 14:54:39 GMT

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.

Re: String Variable In Expression

Greg_Williams — Tue, 01 Jul 2014 14:57:40 GMT

$(vCentre) (if using SET)

vCentre (if using a LET)