Just try to use function for your decimal field in your view: COALESCE(NULLIF(your_view.your_decimal_value, ''), 0)