trying to calculate the percentage of the total for each row in Beast mode. the formulas I have found don't work, because the SUM function only takes one single value per row instead of aggregating all of them. The percentage for each row is 100%. What formula should I use to get a total for all the values under a single column? I also tried ETL with no luck.
thanks,
`actual_hours`
/
(SUM(
Case when `active` = 'true'
THEN `actual_hours`
ELSE 0
END))