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:
All of the numbers are negative 1 for some reason.
What’s going on here?