Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Formula in SQL query

    Hi

    Select

    Income,

    Expense,

    (

    (Cast(Income as Float) - Cast(Expense as Float)) / Cast( ISNULL(NULLIF(Income,0),1) as Float)

    ) * 100 As percentageexpense

    FROM

    (

    select income =4, expense =3

    union all

    select income...

Viewing post 1 (of 1 total)