New LookML runtime issue with multiplication by constant

Our model has many measures calculating a percentage defined as:

sql: 1.0 * ${gmv_variance_yoy_same_weekday_last_year} / NULLIF(${gmv_same_weekday_last_year},0) ;; 

These fields worked correctly until the new LookML runtime was released. I believe the multiplication by 1.0 is intended to coerce the result to a floating point.

If I remove the multiplication by 1.0 the field works correctly with the new runtime. 

If I disable the new LookML runtime the field works correctly as is.

The incorrect values look this:

ce590019-e326-4f72-971e-81ad0337f22c.png
Incorrect Values

All of the numbers are negative 1 for some reason.

What’s going on here?

2 0 151
0 REPLIES 0
Top Labels in this Space
Top Solution Authors