I am trying to find the percentage of the cost of sales from the total cost of sales. I have used the following calculation in beast mode.
(`Cost of Sales` / (SUM(`Cost of Sales`))
However, this calculation is not returning accurate values the lower cost of sales values have a higher percentage than the higher cost of sales values along with this calculation I have other measures/beast mode calculations from my data set inside my table and have changed their aggregation to a sum not sure if that would affect it but will attach a screenshot.