JOINING 3 VIEWS AND USING VARIABLES : I have joined 3 views together to reflect a summary of each view per period
When trying to use 'MC Total' to summarize all 3 it is reflecting as an integer
Have tried multiple options to no avail



Below are the results returned
period_start_date|period_end_date|MC| D/MC|N/MC|MC/Total
2019-08-01|2019-08-15|1,136.99|3,375.77|0|4



Tried with no IF statements
Tried with sub queries
Tried with sub queries and IF statements
Tried formatting 'MC Total'
Tried without variables

```mysql

SELECT
m.`period_start_date`,
m.`period_end_date`,
@meta := IF(m.`Net Collections` IS NOT NULL,m.`Net Collections`,0) AS 'MC',
@dnf := IF(d.`Metacorp Net`IS NOT NULL,d.`Metacorp Net`,0) as 'D/MC',
@nmrc:= IF(n.`Metacorp Net`IS NOT NULL,d.`Metacorp Net`,0) as 'N/MC',
@meta+@dnf+@nmrc AS 'MC Total'
FROM collectionsmax.mc_period_trust_summary m
RIGHT OUTER JOIN collectionsmax.dnf_period_trust_summary d
ON m.`period_start_date` = d.`period_start_date`
LEFT OUTER JOIN collectionsmax.nmrc_period_trust_summary n
ON  m.`period_start_date` = n.`period_start_date`

GROUP BY m.`period_start_date` ,m.`period_end_date`;






```[![enter image description here][1]][1]


  [1]: https://i.stack.imgur.com/gSnd4.png