Forum Discussion
Anonymous
6 years agoNot applicable
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)]))
2 Replies
- AnonymousNot applicable
Hi,
Thanks, though that's not answering the question though is it!?