Report sheets don't match for yearly end values?

ChrisBoar

So not sure what is going on here. Just updated my sheet for 2017 YTD.

But various report sheets don't match with calculated total values YTD.

My dashboard 'Total value' is correct.

The 'Daily' sheet shows the correct 'end value'.

The 'Monthly' and 'Yearly' sheet is showing an end value of about $20K more than actual.

Am I misinterpreting what that 'end value' actually is?

Chris

VidasMatelis

They should match. Total value at the end of the selected period is equal to Total value.
Please check all filters and slicers on each sheet. Did you select the same reported currency?

ChrisBoar

Yep thanks, silly me, had some filters on that were messing up the totals.