New

WHERE NOT ( -- Suppress if both PTD columns are null or 0 (NVL("PTD Earning LC", 0) = 0 AND NVL(TO_NUMBER(REPLACE("PTD Earning (Latest HC)", ',', '')), 0) = 0) AND -- Suppress if both BB columns are null or 0 (NVL("BB PTD Earning LC", 0) = 0 AND NVL(TO_NUMBER(REPLACE("BB PTD Earning (Latest HC)", ',', '')), 0) = 0) )

Comments

Popular posts from this blog

Child query new

child query latest -

final simple where