Forum Discussion
Totals Not Correct on Sum
Hey guys,
I'm sure this is an easy one but why are my totals not reflecting my filters on the page? I am not using measures but rather existing numbers in the table and the sum function.
m4kaveli , please share the measure formula, It may be because of row context
https://www.youtube.com/watch?v=ufHOOLdi_jk
3 Replies
- amitchandak
Super User
m4kaveli , please share the measure formula, It may be because of row context
https://www.youtube.com/watch?v=ufHOOLdi_jk
Thanks amitchandak . Thats what i'm getting thrown off by here because I don't have a measure at all. I'm simply using the raw data and the sm function for the value. Here is the correct list with totals as you could see it adds up. However, as soon as I filter by the cdlinestatscode of CUW, the total doesn't change and remains 8,770.08. So I guess i'm asking why the total doesn't reflect my filter being set.
Before filter showing Total:
After filter showing same total not reflective of my filter:
amitchandak I'm an idiot. LOL. I figured it out. The policy status wasnt' associated correctly to the line. Thanks for leading me to the answer!
