Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Column sum issues

Hi,

 

I've looked at the various solutions and none seem to work. It's the standard issue, that the sum at the bottom, or categoery, is way above what it should be. I've tried the hasonefilter etc, but still no joy. I'm using two tables, though not sure if this is the issue, so it's a rate in one and a quantity in another, multiplying to give an overall total.

 

code costs = if(HASONEFILTER(Data[Job Task Description]),SUM(Data[Quantity])*SUM('std costs'[Unit Cost (LCY)]))