Viz errors out when wrapping an expression in parenthesis

Dan Rosen

I'm trying to run this expression:

([PPM Date: Sum: PPM Total Production] where [Time.Year] = DatePart(Year,NowDate)) / ([Calendar Date: Sum: Working Days] where [Time.Year] = DatePart(Year,NowDate))

The two individual expressions work fine without parenthesis around them, for example:

[PPM Date: Sum: PPM Total Production] where [Time.Year] = DatePart(Year,NowDate)

... but I can't run it with parenthesis without it erroring out, even without the division:

([PPM Date: Sum: PPM Total Production] where [Time.Year] = DatePart(Year,NowDate))

 

I'd rather not have to save these as global expressions just to make this calculation. Does anyone know why this may be happening and how to fix it? Thanks

Diane McElhiney

To clarify, you don’t have any hard returns in the expression? Make sure just to allow wrapping to occur. 
also as a check, what occurs when you wrap the whole expression with the parenthesis on each side of the division in another set of parenthesis?