`(TRUNC({today}) - TRUNC({trandate}) ) +1 - ((((...
# suiteanalytics
m
(TRUNC({today}) - TRUNC({trandate}) ) +1 -   ((((TRUNC({today},'D'))-(TRUNC({trandate},'D')))/7)*2) -  (CASE WHEN TO_CHAR({trandate},'DY','nls_date_language=english')='SUN' THEN 1 ELSE 0 END) -  (CASE WHEN TO_CHAR({today},'DY','nls_date_language=english')='SAT' THEN 1 ELSE 0 END)