Getting error while passing variables in count expression

[saivina2920]

I am getting error while pass variables in count expression.

=count(DISTINCT if((Date(DueDate,'dd-mm-yyyy') - Today() > -5 and Date(DueDate,'dd-mm-yyyy') - Today() < 0) and (CURRENTSTATUS='NEW' and FROM='*BRITTA*' and TO={"$(vManufacturer)"}),DueDate))

Error comes in TO={"$(vManufacturer)"}

What is the problem in the above condition..?

[edwin]

try using single quotes assuming the variable returns TEXT

TO={'$(vManuf)'}

[edwin]

hold on, is that your actual expression?  or the TO={..} in a set analysis?

if in set analysis, try what i suggested but if this is actually a condition in your IF statement, use TO = '$(vManufacturer)'