My Stuff
Comments
-
HINT: [LIST=1] [*]Status needs to use status#raw for the cash flow report[LIST=1] [*]case when {status#raw} = ‘A’ then 1 else 0 end [/LIST] [/LIST]
-
HINT: [LIST=1] [*]Comparison of Date differences for Days Due[LIST=1] [*]Days Due = CASE WHEN TO_NUMBER(TO_CHAR(TO_DATE (TO_CHAR ({startdatetime},'MM/DD/YYYY'),'MM/DD/YYYY') - TO_DATE (TO_CHAR(SYSDATE,'MM/DD/YYYY'),'MM/DD/YYYY')))< 1 THEN CONCAT(TO_CHAR(TO_DATE (TO_CHAR ({startdatetime},'MM/DD/YYYY'),'MM/DD/YYYY') -…