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
Post a Comment