Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..?
try using single quotes assuming the variable returns TEXT
TO={'$(vManuf)'}
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)'