• For clarity, can you share your example schema definition, along with test data indicating the desired output please?

    One suggestion would be to handle the case for 0 within your computed column definition and assigning NULL in it's place.

    create table testTable

    (

    ValueOne int,

    ValueTwo int,

    Calcuation as ValueOne/case when ValueTwo = 0 then null else ValueTwo end

    )

    insert into testTable(ValueOne,ValueTwo) values(1,1)

    insert into testTable(ValueOne,ValueTwo) values(1,0)

    select * from testTable