Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

String Variable In Expression

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.

1 Reply
Greg_Williams
Employee
Employee

$(vCentre) (if using SET)

or

vCentre (if using a LET)