›

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Register

Quick Links

Categories

Report sheets don't match for yearly end values?

ChrisBoarChrisBoar
in General
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

Comments

  • VidasMatelisVidasMatelis
    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?
  • ChrisBoarChrisBoar
    Yep thanks, silly me, had some filters on that were messing up the totals.

Sign In or Register to comment.