diff options
Diffstat (limited to 'sql/dawn.sql')
| -rw-r--r-- | sql/dawn.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 2ed0295e..7dabca9d 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -4892,11 +4892,11 @@ AS SELECT cr.period_end_date AS periodenddate, cr.fund, cr.trade_ccy::currency AS invccy, cr."prime_broker/clearing_broker" AS custacctname, - COALESCE(split_part(cr.strategy, '/'::text, 1), 'CASH'::text) AS port, - COALESCE(split_part(cr.strategy, '/'::text, 2), 'CSH_CASH'::text) AS strat, + split_part(cr.strategy, '/'::text, 1) AS port, + split_part(cr.strategy, '/'::text, 2) AS strat, sum(cr.issue_nav_contribution) AS endlocalmv FROM citco_reports cr - WHERE cr."prime_broker/clearing_broker" ~~ '%_IS'::text + WHERE cr."prime_broker/clearing_broker" ~~ '%_IS'::text AND cr.strategy NOT NULL GROUP BY cr.period_end_date, cr.knowledge_date, cr.fund, cr.trade_ccy, cr."prime_broker/clearing_broker", cr.strategy ORDER BY cr.period_end_date DESC, cr.fund; |