new suppress condition

WHERE NOT ( -- Suppress if PTD pair is null/0 AND BB pair has values ( NVL("PTD Earning LC", 0) = 0 AND NVL(TO_NUMBER(REPLACE("PTD Earning (Latest HC)", ',', '')), 0) = 0 AND (NVL("BB PTD Earning LC", 0) != 0 OR NVL(TO_NUMBER(REPLACE("BB PTD Earning (Latest HC)", ',', '')), 0) != 0) ) OR -- Suppress if BB pair is null/0 AND PTD pair has values ( NVL("BB PTD Earning LC", 0) = 0 AND NVL(TO_NUMBER(REPLACE("BB PTD Earning (Latest HC)", ',', '')), 0) = 0 AND (NVL("PTD Earning LC", 0) != 0 OR NVL(TO_NUMBER(REPLACE("PTD Earning (Latest HC)", ',', '')), 0) != 0) ) )

Comments

Popular posts from this blog

Child query new

child query latest -

final simple where